Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 2

Report other Account Receivables open

When we pay deposits for property we are renting, our accountant in the past put them as into "Other Accounts Receivable". She also put a lot of other stuff in there and we are trying reconcile that account now.

It is a long list of transactions, many having a corresponding offsetting entry (we got the money back from the deposit), however there are quite a few still outstanding amounts.

How can we generate a report that shows all Other Accounts Receivable entries where we paid money out, but have not received the deposit back yet?

Solved
Best answer April 07, 2020

Best Answers
QuickBooks Team

Report other Account Receivables open

Glad to have you back here in the Community, @ChinaUser.

 

You can pull up the Transaction Detail by Account report to view the transactions that are recorded under the Other Accounts Receivable account. This can be done in just a few clicks.

 

Here's how:

  1. Click on Reports at the top menu bar.
  2. Select on Accountant & Taxes.
  3. Choose Transaction Detail by Account.
  4. Make sure that the date range of your report is correct.
  5. Tick on Customize Report at top.
  6. Refer to the Filter tab.
  7. Click on the drop-down arrow under the Accounts section and select Other Accounts Receivable.
  8. Hit on OK.

From there, you'll be able to check all the transactions that were tracked under the said account. If you want to see the entries that are not  yet deposited, you can filter the account into Undeposited Funds

 

For more details about customizing reports in QuickBooks Dekstop, please see this link: Customize reports in QuickBooks Desktop.

 

You can also visit these articles below that provides information about the Chart of Accounts and Accounts Receivable workflow in QuickBooks Desktop for reference:

I'm just a reply away if you have any other questions. i'll make sure you're all set. Have a good one!

View solution in original post

1 Comment
QuickBooks Team

Report other Account Receivables open

Glad to have you back here in the Community, @ChinaUser.

 

You can pull up the Transaction Detail by Account report to view the transactions that are recorded under the Other Accounts Receivable account. This can be done in just a few clicks.

 

Here's how:

  1. Click on Reports at the top menu bar.
  2. Select on Accountant & Taxes.
  3. Choose Transaction Detail by Account.
  4. Make sure that the date range of your report is correct.
  5. Tick on Customize Report at top.
  6. Refer to the Filter tab.
  7. Click on the drop-down arrow under the Accounts section and select Other Accounts Receivable.
  8. Hit on OK.

From there, you'll be able to check all the transactions that were tracked under the said account. If you want to see the entries that are not  yet deposited, you can filter the account into Undeposited Funds

 

For more details about customizing reports in QuickBooks Dekstop, please see this link: Customize reports in QuickBooks Desktop.

 

You can also visit these articles below that provides information about the Chart of Accounts and Accounts Receivable workflow in QuickBooks Desktop for reference:

I'm just a reply away if you have any other questions. i'll make sure you're all set. Have a good one!

View solution in original post

Need to get in touch?

Contact us