Skip to main content
October 15, 2024
Question

Can I get a simple Vendor statement with debit credit and balance on a custom date range

  • October 15, 2024
  • 1 reply
  • 0 views
with usual other simple details as type, date, memo, account, is this possible

1 reply

Bryan_M
October 15, 2024

Welcome to the Community space, @View. I'll guide you on how to generate a vendor statement displaying Debit, Credit, and other columns with a customised date range.

 

To create a vendor statement with your preferred date range and columns, use either the General Ledger or the Transaction Detail by Account report. Just follow the steps below to run and modify the report:

 

  1. Go to Reports.
  2. Type in the General Ledger or Transaction Detail by Account in the Search field and click it.
  3. Select the Customise button.
  4. Input the date range by entering the Report period.
  5. Click on Change columns. Then, tick the boxes of Date, Transaction Type, Memo/Description, Debit, Credit, and Amount.
  6. From the Filter section, choose the correct accounts where your vendor/supplier is categorized in the Distribution Account and Account tabs.
  7. Click on Run report.

 

You can read this article for more information: Create a report that shows Debits and Credits for each transaction.

 

Additionally, to learn more about adding columns to your report, you can visit this article: Customise reports in QuickBooks Online.

 

If you’d like to export your saved report in QBO, feel free to check this article: Export reports, lists, and other data from QuickBooks Online.

 

For any further questions about your vendor statements, you can leave a comment below. We'll be happy to assist. Keep safe, and have a good day.