Skip to main content
December 7, 2019
Question

When i run a debtor statement as a transaction statement, open item, it only gives me the last 365 days. how do i do this for all periods?

  • December 7, 2019
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

December 7, 2019

Good day, @des5.


The Open Item Statement in QuickBooks Online can only show unpaid invoices from the last 365 days. You can achieve your goal of generating the list of open sales transactions for all periods by running the Transaction Statement instead. 


Here's how:

  1. Click the + New button and choose Statement.
  2. Pick Transaction Statement in the Statement Type drop-down.
  3. Choose a Statement Date.
  4. In the Customer balance Status, select Open.
  5. Enter a Start Date and End Date.
  6. Hit Apply.

 

I’m adding this article for the details: Create and view customer statements.


Another way to view the list of open transactions from customers is by running the Accounts Receivable Ageing Detail Report. Filter the Report period to show all the entries.


Follow these steps:

  1. From the Reports menu, scroll down to the Who owes you section and click Accounts receivable ageing detail.
  2. In the Report period drop-down, pick All Dates
  3. Choose an Ageing method and fill out the Days per ageing period, Number of periods, and Min. Days Past Due boxes. 
  4. Hit Run report.

 

Check out this article about pulling up reports in QBO: Run reports.


If there’s anything else you need, let me know in the comment section. I’m here to help. Have a great day!