Create Sales Invoice

Hello ERA,

Welcome to the QuickBooks family! It's awesome that you've got a client you're working with, and I can see how this situation might be a bit tricky to navigate. I have some ideas to share with you so you can explore different ways to record this monthly sales overview in QuickBooks Online.

It sounds like you're working with a pretty unique reporting method outside of the program considering it shows you a wide variety of details from sales to deposits to gift cards and so forth. When using QuickBooks, you might find it's easier to break that into smaller pieces so that you can accurately record the information. For instance, you may be able to tweak the steps for recording daily sales to reflect on a monthly basis, but the method for selling and redeeming gift cards calls for a slightly different approach that might be best handled separately. Here are a couple of articles about the items I just mentioned.

• Record your total daily sales

• Sell and redeem gift cards or certificates in QuickBooks Online

When it comes to something like deposits, it's going to depend a lot on the situation of the books. If the sales are being allocated from a sales receipt to the Undeposited Funds account, then you can later use the Bank Deposit feature to show that those have been put in the bank. I've got another couple articles for you about these two things.

• What’s the Undeposited Funds account?

• Record and make bank deposits in QuickBooks Online

As for journal entries, if you're familiar with how to use them, you could consider it as an option. While it's ideal to use the program's built-in features to ensure accuracy and take some of the accounting work out of data entry, journal entries could still be used, in particular if there isn't a built-in feature that quite does the job. The most important thing with journal entries that you'll want to note is that sales tax must be allocated to its own line item.

Although there is the Sales Tax column on the journal entry form, if you use this on non-sales tax account lines, the program won't track the amounts properly to the Taxes tab for your remittances. When you choose a sales tax account on the journal entry, you're given the option to map to the line you need for a sales tax filing, and it'll then calculate properly. For your reference, here's our article about journal entries: Create a journal entry in QuickBooks Online

As a tech support agent, I can't advise you on the best method for your books, so if you're not feeling sure, my recommendation is to check in with another bookkeeping or accounting professional, in particular one who knows QuickBooks Online fairly well. They'll be able to offer you guidance for this situation to make sure your client's books are balancing properly and entered the way they need to be.

There are accountant users here in the QuickBooks Community, so you may receive another response from one of them to help you along. Keep an eye out for that.

I'd also like to take a moment to share a learning resource with you. When you use QuickBooks Online Accountant to work with your clients, you'll also have access to the QuickBooks Certification training through the ProAdvisor tab in the left menu. This can help you become more familiar with the program so you can move forward with confidence when working with your clients. Here are some details about that.

• QuickBooks Online Accountant

• New Benefits of the ProAdvisor Program

• Manage your wholesale billing plan and wholesale billing clients

Wishing you and your client the best!