cancel
Showing results for 
Search instead for 
Did you mean: 
BrittanySM
Level 2

Balancing AR & AP with General Ledger

Hello everyone,

      Is there a report in Enterprise Platinum that will balance Accounts Receivable and Accounts Payable with my general ledger? I haven't been able to locate them. 

 

Thanks!

5 Comments 5
Catherine_B
QuickBooks Team

Balancing AR & AP with General Ledger

Let me share some insights when running the General Ledger report, BrittanySM.

 

The General Ledger report shows all your business financial activities with debit and credit account records. Since Accounts Receivables (A/R) keeps track of customer unpaid invoices and Accounts Payable (A/P) is an account that tracks all unpaid vendor bills, there's a tendency that these accounts will not balance out.

 

To run the report, you can follow these steps: 

 

  1. Click Reports from the menu and choose Accountant & Taxes.
  2. Select General Ledger.
  3. Set the date on which data you need and click Refresh
  4. You can scroll down to all of the accounts displayed and you'll see both A/R and A/P accounts.

For your next steps in handling reports and for further details, you can view these articles:

 

Let me know if you have other questions about financial reports in QBDT. I'll answer them for you. Take care!

BrittanySM
Level 2

Balancing AR & AP with General Ledger

I'm sorry, I wasn't clear in my first post. I didn't mean for AP & AR to balance with each other. I meant that in our previous system, we had a balancing report for each. An AP balancing with GL, and an AR balancing with the GL. Very similar to a trial balance report. I am trying to determine if QB has a similar report that I can run.

BigRedConsulting
Community Champion

Balancing AR & AP with General Ledger


@BrittanySM wrote:

I meant that in our previous system, we had a balancing report for each. An AP balancing with GL, and an AR balancing with the GL. Very similar to a trial balance report. I am trying to determine if QB has a similar report that I can run.

 

In QuickBooks the GL is a result of all the transactions in all of your accounts. It's all integrated and there really isn't any way for the two to be different / out of balance.

 

Unless, that is, I don't understand what you mean by in balance. What is it the reports in your old system show that helps you?

leigh18
Level 2

Balancing AR & AP with General Ledger

I'm looking for the same type of report.  I run the AR Summary Report at the end of the month and the total on that report should equal the gl account balance for Accounts Receivable.  This month is 8 cents difference, is there a report that would find the discrepancies in what was posted in the two.  

Charies_M
Moderator

Balancing AR & AP with General Ledger

Thanks for sharing your concern to us, leigh18.

 

In QuickBooks Desktop Enterprise, the report that shows discrepancies or balance the Accounts Receivable and Accounts Payable with the General Ledger isn't available.

 

Alternatively, you can export the report as PDF or Excel and manually add the information you want to include in the report.

 

Here's how:

  1. In QuickBooks, go to the Reports menu and select Reports Center.
  2. Find and open any report.
  3. Select the Excel on the toolbar. You can also select Print or Email to save the report as a PDF.

I've added this article to know more about how you can manage Excel files in the future: Import or export MS Excel files.

 

Find out more about managing reports in QuickBooks Desktop through the following articles:

If you need other helpful articles in the future, you can always visit our site: Help articles for QuickBooks Desktop.

 

The Community is always open if you have other questions while working with reports. Wishing you have a wonderful day ahead.

Need to get in touch?

Contact us