Understanding statement of account
Prerequisite: Select Enable Wholesale Options in Manage Orders Action Menu in the Client Settings. This will set the Generate Statement of Account options (PDF and Excel) in the Action Menu on the Manage Orders page.
You can use this statement in different ways, such as sending the PDF file to your customers as a statement for billing purpose, or using it as an Accounts Receivable (A/R) Aging Report for customers with credit terms for payment(s) due.
Creating statement of accounts
To create this statement:
- Click Orders > Search for orders > Select desired orders > click Action Menu > Generate Statement of Account (PDF or Excel) > Go.
- Click the downloaded report to open it. Check out a sample statement showing a single invoice from a whole report:
The table below defines each of the columns:
COLUMN | DESCRIPTION |
Statement Date | Auto-populated generation date of the report. |
Customer # | Sold-to customer on the order. |
Company | Sold-to company on the order. |
First Name | Customer first name. |
Last Name | Customer last name. |
Customer email address. | |
Phone | Customer phone number. |
Invoice Date | Date the invoice was created. |
Invoice # | Unique order identification number in Sellercloud. |
Channel Order # | Unique order number from the channel. |
Credit Terms | Invoice payment terms; for example, Net 30, etc. |
Due Date | Date that the invoiced amount is due. |
Invoice Amount | Total amount of the invoice. |
Balance Due | Total amount that is owed on the invoice. |
Running Balance | Previous balance (if any), plus current balance. |
0-30 Days | Days aged from the invoice due date. |
31-60 Days | Days aged from the invoice due date. |
61-90 Days | Days aged from the invoice due date. |
90+ Days | Days aged from the invoice due date. |
Understanding statement of account
The Statement of Account is a detailed report of selected orders, per customer, showing all of their invoiced amounts and payments, with the running balances of any invoice payments due, and any aged balances as 0-30, 31 to 60, 61 to 90, and over 90 days based on credit terms.
You can use this statement in different ways, such as sending the PDF file to your customers as a statement for billing purpose, or using it as an Accounts Receivable (A/R) Aging Report for customers with credit terms for payment(s) due.
Creating statement of accounts
- Click Orders > Manage Orders > Select desired orders > Action icon > Generate Statement of Account (PDF or Excel).
- Click the downloaded report to open it. Check out a sample statement showing a single invoice from a whole report:
The table below defines each of the columns:
COLUMN | DESCRIPTION |
Statement Date |
Auto-populated generation date of the report. |
Customer # |
Sold-to customer on the order. |
Company |
Sold-to company on the order. |
First Name |
Customer first name. |
Last Name |
Customer last name. |
Customer email address. |
|
Phone |
Customer phone number. |
Invoice Date |
Date the invoice was created. |
Invoice # |
Unique order identification number in Sellercloud. |
Channel Order # |
Unique order number from the channel. |
Credit Terms |
Invoice payment terms; for example, Net 30, etc. |
Due Date |
Date that the invoiced amount is due. |
Invoice Amount |
Total amount of the invoice. |
Balance Due |
Total amount that is owed on the invoice. |
Running Balance |
Previous balance (if any), plus current balance. |
0-30 Days |
Days aged from the invoice due date. |
31-60 Days |
Days aged from the invoice due date. |
61-90 Days |
Days aged from the invoice due date. |
90+ Days |
Days aged from the invoice due date. |