Account Receivable payments in trial balance report

Hello Kirill_K,

Thanks for walking me through the steps you're taking with your customer invoices and trying to see the data on the Trial Balance Report. I want to make sure you're able to get to the bottom of why the information is appearing the way it is so you can get back to business. I'm here to help.

When it comes to the Trial Balance Report, the Debit and Credit side should ultimately equal the same amount and the report should update as you add transactions to your books. The invoice, payment received, and deposit into the bank account appear in the Debit column of the report. They'll be reflected on the Debits side of the Trial Balance Report as follows.

• When you create the invoice for the customer, you'll see the funds in the Accounts Receivable on the Trial Balance Report.
• When you create a payment for the invoices, you'll see the funds in the Undeposited Funds account on the Trial Balance Report.
• When you deposit the payment, the Trial Balance Report will reflect the funds in the bank account the funds were deposited to.

You can see this movement in action when you complete these steps as well. After each step, feel free to check the report to see where the funds have moved to.

For the Credit side, the funds will reflect based on what kind of item was on the invoice, and you'll see it in the income account related to it that you would have picked when setting it up. For instance, if I create an invoice for a service, on the Debit side of the report, I'll see the amount moving around the accounts like I outlined. For the Credit side, the invoice transaction will stick in the Services account. For me, this is at the bottom of the report.

To get a clearer sense of the transactions in each line of the report, hover over the numbers until you see the magnifying glass. Once that's there, double-click and the program will open an additional report to show the transactions.

As long as you're seeing the amounts in the accounts like I've outlined and the debits equal the credits, you should be good to go. If you're feeling uncertain, however, feel free to touch base with an accountant to get their expertise. To find someone to work with, check out the Find an Accountant page to see a database of QuickBooks-certified accountants.

For more information about reports, you can take a peek at the following article and the other related articles linked to it: Understand Reports

I hope that helps!

Hi Laura,

Thank you for prompt reply.

I think I figured it out.

I am used to see trial balance this way:

Opening balances | Total Debits | Total Credits | Closing balances

Is there a way to display trial balance in QB this way?

Thanks,

K

Thanks for the follow-up with what you're looking for. QuickBooks Desktop doesn't have a specific configuration where you can see simply opening balances versus closing balances on that report. The description for the Trial Balance Report in the program is as follows: "What is the ending balance for all accounts?" This means, the report shows you the ending balances, rather than both the opening and closing balances.

At this point, an accountant is your best resource for fine-tuning what you're seeing in the Trial Balance Report and how you're recording your transactions. They may also be able to help you find another report to find the details you're looking for. If you're not already working with an accountant, feel free to check out the Find an Accountant page to see our list of QuickBooks-certified accountants in your area.

Wishing you the best.