top of page

Accounts Receivable
Agent statement
We regularly send account statements to agent where they can visualize the outstanding invoices or credits in their account.
5.1 How to create an agent statement
-
Open Accounting
-
Choose Debtors
-
Open Agent Statements
-
For Agent Statement Msg choose ACA1
-
Type in the Agent Code from and to (to type twice the same code)
-
For Include Nil Balance Agents choose Skip Future + Current Nil Balances
-
For Include Transactions choose Include Nil Balance Transactions, Include Future Entered Transactions and Include Future Aged Transactions
-
For Output choose Editor
-
Click on Print
5.2 How to create an agent statement in excel
-
Create the statement in Tourplan
-
Copy all the Transactions into an excel file (only outstanding files)
-
Delete the first column
-
Below you can see the necessary columns
-
Add the total of the transactions in the end

bottom of page