How to View and Export Supplier Account Statements

Explanation of how to view the supplier account statement in the system and export the report.

Steps:

1. From the main menu, go to Reports.

2. Select Account Statement Report.

3. Select Accounts Payable.

4. In the filter type, choose Suppliers, then select the supplier name from the dropdown list.

5. You can select a specific project (optional)

6. Select the appropriate Date (you can specify a certain period).

7. Click Search to display the report.

This report shows you all the transactions related to the supplier during the period you specify, and begins with the Opening Balance (which is the total balance before the start of the period).

Then all the transactions appear in a clear table, such as:

• Vouchers

• Invoices

• Debit Memos

• Manual Entries

• Simple Invoices

And for each transaction, it will show you:

• Date

• Transaction Type

• Description

• Reference Number

• Amount (Debit or Credit)

• Balance after the transaction (cumulative)

• Project (if applicable)

And at the end of the report, you will find:

• Total Debit

• Total Credit

• Net movement during the period (whether debit or credit)

• Closing Balance

  After reviewing the supplier account statement, you can export the report to PDF or Excel through the Export icon at the bottom of the page.

Additional Notes:

• You can customize the time period for displaying the account statement based on your needs.

If you need an account statement for all suppliers or customers, you can use the Trial Balance

Steps:

1. Access the Trial Balance Report

   • Go to the Reports section in the system.

2. Show Detailed Accounts

   • At the top of the Trial Balance report, you will find an option called “Show Detailed Accounts (Customers, Suppliers, Employees, and Fixed Assets)”.

   • Enable this option to display all supplier and customer names instead of the aggregated accounts “Accounts Payable” and “Accounts Receivable”.

3. Update the Report

   • After enabling the option, click “Search” to update the data.

   • Then scroll down to the Accounts Payable or Accounts Receivable account to view the details.

In this way, you can view a statement with all supplier and customer names along with their balances,
and if you need details of a specific supplier or customer account, go to their account statement.

Additional Notes:

• Make sure the system contains detailed data for each supplier or customer so they appear correctly in the report.

Search Keywords:

I want to extract a complete account statement for all suppliers

Search Keywords:

• How do I view an account statement for a supplier?

• Where do I open the supplier account statement report in the system?

• Where can I find the detailed supplier account statement?

• How do I search for a specific supplier account statement?

• Can I filter the account statement for a single supplier?

• How do I select the supplier in the account statement report?

• Can I view a supplier account statement for a specific period?

• How do I view a PDF version of the account statement?