cancel
Showing results for 
Search instead for 
Did you mean: 
jhardyman
Level 1

Accounts Payable Showing Debit and Credit on Expenditures Report

I am currently using Quickbooks Desktop 2018.  I started to use the bill function for vendors rather than just cutting checks.  I noticed when I pull a report of our expenditures, the Accounts Payable account shows a duplicate entry, one as a credit and another as a debit. Is there a way to only show the amount paid per line not the total for the check as well?  I've attached a screen shot to show you what I mean. 

Specifically for Xerox, there are two bills being paid: one for $266.85 and the other for $217.74.  The two bills amount to $484.59 or the total of the check.  Can the total of the check be omitted or vice versa since the split will show on the accounts?

Thank you!

3 Comments 3
Joseph_A
QuickBooks Team

Accounts Payable Showing Debit and Credit on Expenditures Report

Welcome to the Community, @jhardyman.

 

You're seeing a duplicated transaction because QuickBooks uses double-entry accounting. Where every transaction records in at least two accounts, one as a debit and the other as a credit. Debits and credits affect different types of accounts differently.

 

I have tried replicating on my end and the bill will be paid in total. That's why the total will show on the report. If you want the payment to show separately you can create a separate bill.

 

To create a bill here' how:

  1. Go to Vendor then Enter Bill.
  2. On the Vendor dropdown select your vendor's name.
  3. Enter the item and amount for the bill.
  4. Click Save and New once done.

You can also customize reports in QuickBooks desktop.

 

Feel free to comment on this thread if you have additional questions. Take care and keep safe.

jhardyman
Level 1

Accounts Payable Showing Debit and Credit on Expenditures Report

I am going to try and setup a customized report.  Thanks for your help!

Anna S
QuickBooks Team

Accounts Payable Showing Debit and Credit on Expenditures Report

Good to hear from you again, @jhardyman.

 

You're most welcome. I also appreciate your taking the time to post this to let me know that the issue is resolved.

 

As always, Community is full of experts possessing knowledge in all facets of QuickBooks, so please reach out to us here if there's anything you need. I'm always happy to help you along your road to victory. Wishing you and your business continued success!

Need to get in touch?

Contact us