Accounts Payable - Old enteries

Thanks for posting to the Community, @DJBSTB.

Let me provide you the solution for the first and second items. Please know that adding a pledge is like entering an invoice. It should show on the AR, it won't reflect on the AP. You can verify the associated transactions that total 87,000+.

In item 2, you entered an amount, and as a Bill Payment with no bill entered and paid it by check. You can create a bill here to offset the check. You can apply the steps in Solution 3 to this article: Bill shows as unpaid after writing a check in QuickBooks Desktop.

Thirdly, let's pull up the Accounts Payable Aging Details Report. There you can see the outstanding bill and the possible reason why you have an AP balance to match it with the bill payment:

1. Go to the Reports menu.
2. Select Vendors & Payables.
3. Choose A/P Aging Detail report.

For other options to remove the AP balance, you can refer to the article given above.

You can also consult your accountant for more details in fixing AP balances.

Please let me know if you have further questions. I'm always here to help. Have a good one!

So.. I have followed the instructions you sent me.  However the first stumbling block is when I pull up he check it does not show

the expense account.  I have to open the Pledge to see what expense accts it paid to. 

Same with the second check- I have to look at the deposit to see what expense accounts were paid. 

Hello, @DJBSTB.

You can run and customized the Transaction Detail report. By doing this, you'll know the accounts associated to each of your transactions.

Here's how:

1. Go to the Reports menu.
2. Choose Custom Reports.
3. Select Transactions Detail.
4. Click the Customize Report button.
5. Pick the Filters tab.
6. From the Filter section, choose Transaction Type.
7. Select Check transaction.
8. In the Display, make sure to include the Accounts column.
9. Set the Date Range of the transaction you want to see.
10. Click Ok.

Once you're able to determine the account associated to the check, you can use the same account in tracking your transactions. You can refer to this article for more detailed steps: Customize reports in QuickBooks Desktop.

You can also read through this article to learn more about tracking the expenses for a job and comparing those expenses to your revenue:  Tracking job costs in QuickBooks Desktop.

Let me know if you have other questions. The Community and I are always here to help.

Thank you so much for your response.  I have looked at the custom transaction report as you suggested.  It does not, however, show the checks that were written that are still in the Accounts Payable register.  

Hey there, @DJBSTB. Thanks for reaching back out.

Let's try using a different report to show this information. I recommend trying the Transaction List by Vendor report. It will break down the checks by Vendor and allow you to see which Expense accounts the checks were split into. Check it out:

1. Go to the Reports menu, Vendors & Payables, then Transaction List by Vendor.
2. Within the report, click the Customize Report button.
3. Navigate to the Filters tab and search for Transaction Type.
4. In the Transaction Type drop-down, select Check.
5. Hit OK.

Now you'll see the associated expense accounts for the transaction under the Split column, as shown below.

That's it! Since my colleagues have provided all of the relevant resources on the topic, you can reference their posts if you'd like more information on customizing reports.

Let me know if you have any other questions by shooting me a reply. I'll be here waiting to help.