/r/Bookkeeping

Photograph via snooOG

The place for all things bookkeeping!


Welcome to /r/bookkeeping

All are welcome, whether you're a bookkeeper, small business owner, office worker, or any random person interested in better understanding bookkeeping!

There's no such thing as a stupid question!

We strongly encourage any and all posts that have anything at all to do with bookkeeping, including:

  • Questions on a specific bookkeeping problem or how to do something.
  • Questions on dealing with bookkeepers or dealing with others as a bookkeeper.
  • Anecdotes and other posts about what it's like working as a bookkeeper for a big company or independently.
  • Relationships between bookkeepers and clients, bosses, accountants, accounting software companies, or the general public.
  • Bookkeeping related jokes, puns, memes, riddles, etc.
  • The practical application of bookkeeping practices to personal finances and everyday life.
  • Anything else that you consider bookkeeping-related.
  • Posts regarding /r/bookkeeping itself are acceptable, however, we suggest running your ideas by the moderators first.

Rules/Policies

  • Rule #1: NO SPAM! If you solicit business for your company, or post/comment links to pages that are blatantly advertising a product or service, you will be banned.
  • Rare exceptions may be made for comments where the link is clearly relevant to the post's discussion.
  • Rule #2: Don't be a jerk. Be respectful, offer constructive criticism, keep debates civil.
  • If you are being a jerk, you had better be offering some genuinely constructive comments in your jerk-y tone, or we won't think twice about banning you.

Other general guidelines

  • We are an inclusive community. Please be respectful to others, whether they are bookkeepers or not.
  • If you feel that someone is giving incorrect advice or behaving rudely, please correct them respectfully.
  • If you feel that someone's post is irrelevant, or stupid, or something you've already seen posted, please keep it to yourself. We want /r/bookkeeping to be a place where everybody feels welcome to post. (If a post is irrelevant, it will receive few up-votes and be quickly buried anyway, but comments that make someone feel dumb for posting are rude and accomplish nothing.)
  • If someone is being an unconstructive jerk or spamming, please use the report button to let the mods know.
  • Frequent contributors will be granted flair, with the default being "frequent contributor." Once granted flair, you have the power to tell us to make your flair say anything that you'd like. We do encourage using professional designations as your flair.
  • If you have questions that specifically regard tax-law or accounting school/career planning, you will likely find better answers in /r/accounting.
  • Finally, /r/bookkeeping functions as a democracy and we encourage all subscribers to propose ideas for the sub. We'd like all major changes to /r/bookkeeping to be made with community involvement. Please message the mods with any thought, ideas, etc (including feedback on the side-bar rules you just finished reading). You will not be ignored.

Traffic Stats Now Public! http://www.reddit.com/r/bookkeeping/about/traffic/

Some related subreddits:

/r/accounting

/r/QuickBooks

/r/excel

/r/smallbusiness

/r/PersonalFinance

/r/Entrepeneur

/r/Bookkeeping

48,634 Subscribers

1

How granular does Gusto and QBO sync get?

I have employees who work in different departments and I expense each line item in a different GL account. I get very granular with it. Currently I put everything into a fancy spreadsheet that breaks down all the different costs into the right accounts and then upload an JE into QBO.

I do this so I know the % of expense each department uses.

2 Comments
2025/02/01
01:26 UTC

3

Where to find a bookkeeper familiar with healthcare

Hello,

I am trying to locate a bookkeeper that would be a good fit for my business. I do not particularly care if this person is also a CPA/my CPA, but ultimately I would like to find someone that is familiar with the healthcare industry. I am not entirely sure where to look, but I don't want to keep Google searching "bookkeepers near me" if that can be avoided.

I am in near Pittsburgh, PA, but that doesn't entirely matter. I would almost prefer if the bookkeeper and the CPA were two separate services, or at the very least 2 separate people.

TIA, and apologies if this is not the right place to post something like this.

5 Comments
2025/02/01
01:04 UTC

2

1099-NEC

Just finally got all information into QB for the three contractors we need to send 1099-NECs for. I paid to file online through Quickbooks. Do I also need to print a copy to mail to the recipients? Or is that done for me? It says "Mailed" but want to double/triple check that means I'm done.

1 Comment
2025/01/31
21:53 UTC

2

QuickBooks enhanced payroll?

My accountant unexpectedly passed away. I don't know if this was against the TOS but they allowed me to do my own payroll using their enhanced payroll subscription.

Because they are no longer my accountant I am seeking out a new payroll service. I contacted QuickBooks and I would have to upgrade to enterprise, so basically $1000 for a year of payroll. Which isn't terrible but I'm not used to that expense.

My question is, if it isn't against TOS are there any bookkeepers or accountants that have enhanced payroll that would allow me to pay them so I can use your subscription?

3 Comments
2025/01/31
21:43 UTC

1

Separating Credit Payments VS Interest on a credit card

I have a client that has a billion credit card payments and the way it comes in doesnt show if its a payment or an interest charge.

I probably shouldnt just mark them all as a payment right? I would need to designate the difference of interest vs payments in quickbooks right?

15 Comments
2025/01/31
18:42 UTC

1

How to fix error involving locked paychecks and payroll liabilities... (Quickbooks Desktop)

What a mess. We are on QBD Pro and are manually calculating payroll. We made a SS withholding miscalculation and over withheld $27.53 x 2 (employee + company) for a total of $55.06 from one employee.

We caught it while auditing before submitting W-2/W-3 for 2024.
So, the W-2/W-3 was submitted with the correct adjusted amount. (Too late if that was a bad idea, but I didn't want to make this a problem for the employee's tax return - would rather handle it on our end).

The 941 has not been submitted yet, but I was planning to submit that with the adjusted corrected amount as well.

So, that leaves me with a clerical QBD issue and an IRS payment reconciliation issue.

  1. What is the easiest way to give the employee the $27.53 they are owed on LAST YEAR's pay and correct our numbers in Quickbooks? (This touches locked paychecks and payroll liabilities, which is why I'm not sure how to proceed).
  2. What happens when you over-pay on EFTPS? How do I get the $55.06 handled. I'm actually less concerned about the $55.06 than the possibility that we start getting notices about being out of balance.

Thanks for any suggestions.

5 Comments
2025/01/31
18:40 UTC

3

Arts Nonprofit: Square Payroll vs Gusto

Hello! first time caller, long time listener. i just started an arts nonprofit, Sketchboard Co, last year and trying to figure out a payroll system to use for our staff.

Right now, our ticket sales are integrated with Square, via Acuity Scheduling - a Squarespace booking app. And everything is automated to direct deposit to our bank account. But been reading up how Gusto is more efficient.

The great thing is that these two can integrate with Quickbooks. We pay our art teachers, models, and musicians that way.

Any advice on what direction to take?

8 Comments
2025/01/31
17:34 UTC

2

What is your solution to keeping recurring due dates for multiple companies?

4 Comments
2025/01/31
15:41 UTC

3

Budget spent YTD reports for treasurers

Hi all!

We currently use QBO for our accounting platform and Bill.com for AP approvals. My treasurers (2 entities) asked me if there’s a way, when approving invoices, to see where we are on YTD spend in this category. The only thing I can come up with is an expense budget to actual YTD scheduled report to automatically export from QBO on a weekly basis. But they’re wondering if it’s possible to see WITHIN Bill.com. I’ve asked Bill.com and they say it’s not possible.

Has anyone come up with any different solution so our treasurers can feel more proactive rather than reactive?

And I will note, this is more MY job to let them know when we are over budget, but we have so many expense categories that I analyze overall picture of the organization, not specific expense budget items. I think the treasurers may be too involved on a granular detail for my liking, but alas this is where I’m at.

1 Comment
2025/01/31
14:46 UTC

0

I wanted to have a free internship QBO or Xero

Hi, I really wanted to be a virtual bookkeeper. I already have two trainings and already got my certificates both QB and Xero. I also have a bachelors degree, All I need is that one more push to be confident. If you wanted to be my mentor, I am willing to help for free.

7 Comments
2025/01/31
12:36 UTC

2

1099 NEC Box 7

If the payer and recipient are both in Florida is box 7 of 1099 NEC needed? Can it be blank? Thanks

0 Comments
2025/01/31
01:39 UTC

2

Freshbooks balance sheet

Balance sheet for newbie Hi I had to repost cause auto bot thought I was asking for advice on how to become bookkeeper lol

Hello. I'm beginning some bookkeeping classes at college to help my understanding in running our business better. I have a basic understanding of accounts but it's mostly how my software works that's confusing me. We use freshbooks ( I want to use QB but hubby insists on keeping freshbooks so it's out of the question) and I was preparing our accounts for our taxes to send to tax guy. I noticed in our balance sheet we had a huge liability under credit cards. We pay our cards off throughout the month and never carry a balance. It was like 60K in liability. I have been reconciling all the transactions and always select transfer under the cc account when it's paid off (NOT an expense obviously) so my question is why isn't it being applied to this account? Why does it show we have 60k? Is this something I have to go in and somehow apply to the credit card liability account manually every single time I make a payment on it? Any help is appreciated especially from others familiar with crappy freshbooks!

2 Comments
2025/01/31
01:16 UTC

3

What can I recommend to clients for Sales Tax?

I don’t do sales tax or payroll. I partner with Gusto for payroll. What can I recommend to people who need their sales tax done. I’ve seen tax jar and avalara but I’ve heard complaints of them being shoddy or too expensive. I don’t really want my lack of sales tax be the reason I get or don’t get a client.

21 Comments
2025/01/31
00:21 UTC

1

1099s on Venmo payments?

Poll : Did you issue 1099s this year on Venmo payments? Paid out of a business checking account via Venmo for services provided to the business, paid under friends and family, under $5,000, where Venmo would not issue a 1099K. I have heard back and forth, wondering what you all did this year. Thank you! ;)

1 Comment
2025/01/31
00:12 UTC

5

Owner Distribution Question

Hi, might be a dumb question but I am a little out of my depth here. Are owner distribution and contribution accounts closed out at the end of the year?

If so, what should I do to fix prior year’s balance sheets on QBO? Previous 2 bookkeepers who trained me never said anything about it and it doesn’t look like they ever closed out the account so it just shows the all time balances when I pull up the BS. Now I am panicking because I am not sure how to fix this or if I need to see professional help.

10 Comments
2025/01/30
23:47 UTC

3

Security and Public WiFi?

Until now I’ve worked remotely (from my home) and just taken time off when I travel.

We have an unexpected trip coming up I’ll need to do some work during it. I’m concerned about security on public wifi but honestly I’m not that well-read on security measures for that kind of thing — understanding all of the safety guards and security measures and software and I don’t even know what a VPN is supposed to be doing or not doing — it’s very convoluted to me.

The few rare times I’ve had to check something I’ve used my cellphone as a hotspot instead of public wifi.

What do I need to do to stay safe and keep my clients data safe? Is there a way to use public wifi safely or is there something else I need to look into for this? Is there any resource that breaks down what I need and why in an accessible way so I can understand it?

3 Comments
2025/01/30
23:03 UTC

1

Processing Fees

What is the best way to account for credit card processing fees in Quickbooks? We are charged a fee when a customer pays by credit card, so we pass along the fee to the customer. I have Credit Card Fee setup as a product/service and include it on customer invoices. Should my Credit Card Fee product/service be mapped to Service or Non Inventory Item? Do I check the Sales or Purchasing box below that, and which Income or Expense account from there? Thank you!

4 Comments
2025/01/30
22:00 UTC

2

End of year/deferred revenue help

End of year/deferred revenue help

Hi everyone! I do the accounting for a small business (we put out special interest news for a certain business sector in the form of magazines, newsletters, emails, social media, etc. Revenue is made mostly from advertising in our publication.

Disclaimer: there is absolutely no documentation of a year end closing process and it's something that I've never done before this job. I was not trained at all for this, and have pretty much been googling how to do everything. I work with QB desktop also.

I'm trying to figure out deferred revenue. The monthly process that I go through for billing is as follows:

  1. Create invoices on the 22nd of the month for ads running next month (debit AR/credit def rev)
  2. At the end of the month, I pull the revenue report from our ad system, compare it to QB and do a journal entry, debit def Rev and credit each revenue account for the different advertising placements (magazine, email, social, etc).

When the customer makes a payment in advance, I enter it under the receive payment screen and enter the payment info (QB is set up to debit undeposited funds and credits AR). Then I have to make deposits, which debits our checking account and credits undeposited funds.

Should I be doing this a different way?

I know def Rev = cash received in advance - sales revenue. So how do I correctly show the prepaid amount and put it to def Rev?

Also, any year end closing tips and tricks would be super helpful!

Thank you so much!

6 Comments
2025/01/30
20:43 UTC

8

Tracking Amazon Expenses

I have QBO clients who shop predominately through Amazon for their business needs, and I need a better way to find out what is actually being purchased. Does anyone have an addon they use or integration software that pulls in the details of the purchase from Amazon to QBO? Or even just a process for tackling this issue. Sending lists of 100+ amazon transactions each month to the client asking, what was purchased, isn't working and I've never seen it done any other way.

12 Comments
2025/01/30
19:21 UTC

3

Multiple Accounting Softwares?

Hi everyone, I'm going to be starting my own bookkeeping and tax preperation business soon here in Ontario, Canada (shout out to any Canadians in this group!).

I just have some questions for Bookkeepers who have certifications or have proficiency in multiple accounting softwares like Xero, QBOA, etc.

1.) How do you manage handling all these softwares? Which one do you use to keep track of your own books, invoicing, etc.? Like do you use Xero if the client requests it but still invoice/bill them via QBOA if that's where you maintain your own books?

2.) Should I just stick with learning and mastering one accounting software or diversify myself in learning multiple? I'm currently getting my ProAdvisor certification but wondering if I should also try getting certifications in Xero and Sage?

Any advice would be greatly appreciated. Thanks!

8 Comments
2025/01/30
17:10 UTC

1

Need some help with QBO - receiving a payment from a customer that's net of an expense

I recently switched from Sage to QBO so I'm not sure how to handle this specific situation in QBO.

In a nutshell, we get paid commissions from customers but sometimes a commission is "clawed back" if a deal goes bad.... sometimes the commissions/deposits we receive from the customer are a commission on one deal NET of a claw back....

so for example, we will receive, let's say $1,500 from a customer which is made up of a $2,000 commission and a clawback of $500 resulting in the deposit of $1,500.

The $500 needs to be debited to an expense account. How do I handle this? Sage would let me enter a sales invoice for a negative amount. So that way I'd be able to "receive payment" for both the 2k and the negative 500 to net $1,500.

QBO won't let me enter a negative sales invoice amount. I also can't enter is as a bill and then receive a payment for both the sales invoice and the bill to net together.

any ideas?

18 Comments
2025/01/30
15:42 UTC

1

Sales tax e-filing, client logins

We have about 150 clients we file sales tax for, either on a monthly, quarterly, or annual basis. We’re located in AZ, which offers a small credit if you e-file, so obviously our clients are more inclined to e-file rather than paper file. The problem I’m running into is that it’s very difficult to maintain the logins for all of these clients. If they’re monthly, it’s a little easier because we’re frequently in contact with them about it, but for our annual and quarterly filers, the password has almost certainly expired (password reset every 90 days), so each period we have to coordinate with them to reset their passwords. Many of them have difficulty even figuring out how to log in themselves, so it’s a real pain to get all of it done timely.

So my question is, how do you maintain logins for your clients? If you’re in AZ, does anyone know if there’s a way to have one login for us (the firm) and connect our clients to our account? My guess is not since the website looks archaic as is, but that would be my ideal solution.

3 Comments
2025/01/30
14:17 UTC

2

Bookkeeping to tax affiliate

For those that have a partnership or an affiliation agreement with a CPA/EA would you mind sharing the splits? I'm having conversations with a small bookkeeping firm that wants to partner up with me to have their clients use me to prepare taxes.

I understand there are factors involved, but assuming that it would be "off the top" and not after software costs, etc and/or flat fee per return. Suggestions?

1 Comment
2025/01/30
13:17 UTC

3

Start Up Cost

I loaned my LLC money to purchase an insurance policy necessary for business. I would like to now reimburse myself for that cost, as I have the money in my business account. How do I show this in QB (the initial loan, and the repayment to myself)?

8 Comments
2025/01/30
12:44 UTC

13

I totally undersold myself and got myself underpaid and now I want to ask them for more money. How much to ask for and how to justify/explain?

I joined on with a small company that offers bookkeeping and controller/CFO services. I just really wanted a side job and was looking for any opportunity. I settled on $25/hr and…I really should have asked for more. I’m only 3 weeks in and already feel very underpaid. I only work for them around 20 hrs/week (though they try to get me to do more) but I feel like I’m working harder on this job in 20 hrs than I am at my actual job in 40 hrs where I make $85k or the equivalent of like $40/hr.

They have me doing so much stuff. They want me to fix all the accounting issues on all these shitty clients they’ve taken on. I haven’t looked at a client yet who didn’t have books littered with issues. The lady who is in charge of these clients is clueless. She’s apparently halfway through a Bachelor’s in accounting but she doesn’t even know basic debits and credits. So I feel like I’m doubling as an accounting professor because they want me to effectively teach her accounting while doing the bookkeeping for these clients.

They also want me to eventually do more “CFO work” and help clients with budgeting and forecasting and cost cutting after I get this lady up to speed on how to be an actual accountant. But I suspect I’ll be doing this “CFO work” on top of still helping with the bookkeeping.

And on top of all that, the lady basically tries to get me to work from like 7-11 in the mornings and 5-9 in the evenings. Which some days I’m OK with but some days I can’t or don’t want to work all those extra hours. She even messages me on days and weekends where I explicitly said I would not be available. So I feel if they’re not actually gonna be as flexible as they claimed they were gonna be, I want more money for that too.

How much of a raise would you ask for and what do you think is the best way to request it and explain/justify my reasoning?

32 Comments
2025/01/30
11:21 UTC

1

Basic Program

What's a simple program I can try out? Right now I am using QB Desktop, but need something I can use online to be able to access from home. I really only use QB to track our bank accounts; reconcile each month to generate financial reports to be used for taxes and such. And also to cut checks. I don't use it for invoicing, payroll, etc. I'm the only one who accesses it and don't send anything to outside people/vendors. We are a small business, and have a CPA.

1 Comment
2025/01/29
23:36 UTC

9

Owner’s wife using a company cc

Just looking for the best way to advise my client. He is a sole proprietor 100% owner. His wife has no official role in the business but has & uses a company credit card in her name only. Is this best practice or is there a better way to handle these expenses?

40 Comments
2025/01/29
20:53 UTC

3

Non-profit bookkeeping

I'm a QuickBooks gal. I've been using it for over 25 years, both desktop and online. I know it has its quirks sometimes, but I'm used to it.

That being said, I've always used my clients' QB so cost has never really been a factor. Most clients are regular small businesses, but I've had a few non-profits.

So, now I have a non-profit who wants me to do their books. The CEO is elderly, had a few strokes and is now having his daughter take over. I'm going to have to catch up about 3 years worth of books so that 990s can be filed.

They used to use QuickBooks, but now feel the cost is prohibitive. The platforms that are non-profit specific also seem quite expensive. What do you use for your non-profit organizations?

Thanks so much.

8 Comments
2025/01/29
20:22 UTC

9

Restaurant accounting

I have two restaurant clients and am wanting to further develop my knowledge in this sector. Particularly restaurants with revenue around $100,000/month and located in my state. My general accounting knowledge is extensive, but I am a little confused about particular inventory purchasing, tracking, and costing. With restaurants this size they seem to not want to do much regarding inventory, but there are many reasons this needs to be done.

Does anyone have tips on how they realistically approach this? Does anyone have suggestions on resources?

22 Comments
2025/01/29
19:52 UTC

Back To Top