cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
Raymdlee
Level 1
posted
‎September 24, 2021 11:47 PM
last updated ‎September 24, 2021 11:47 PM

How to generate debtor/creditor ledger for a range of period?

Most of the accounting software can generate debtor or creditor ledger which shows all transactions (credit and debit) within a selected period, but it appears that Quickbook is not able to perform this.

In addition, I've tried to generate one using customer/supplier balance detail to generate something which may barely pass as a debtor/creditor ledger. However, under this option, it is not possible to generate a report for this-year-to-date (selected date).

Anyone can advise a way to solve this?

Reply
1 Comment 1
Angelyn_T
QuickBooks Team
QuickBooks Team
‎September 25, 2021 02:48 AM

How to generate debtor/creditor ledger for a range of period?

Hi there, Raymdlee.

 

You can pull up the Transaction List by Date report to generate a debtor or creditor ledger for a specific period. I'll guide you on how.

 

  1. Sign in to your QuickBooks Online (QBO) account.
  2. Click on Reports at the left pane, then look for Transaction List by Date.
  3. Open the report.
  4. Filter the Report period to This Year-to-date.
  5. From the Account to Debtors and Creditors from the Customise tab.
  6. Tap on the Run report tab to refresh the page.
  7. You can also customise the columns you want to add to the report through the small gear icon.

 

For additional resources while handling your reports, you can open this article: Run reports in QuickBooks Online.

 

You can also utilize the general ledger report to see the list of transactions from all accounts for a specific date range. You can open this link as your guide: General Ledger: Meaning, Classification, and Examples.

 

If you have any other questions about pulling up a debtor or creditor ledger, please feel free to leave a comment below. I'll get back here as soon as I can to help you again. Thanks for coming, wishing you a good one!

Reply