Statement of Account is a detailed report of selected orders, for each customer, showing all of their invoiced amounts and payments. It shows the running balances of any invoice payments due grouped by the number past due.
You can use this statement in different ways, such as sending a PDF invoice 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.
Create a Statement of Accounts
Prerequisite: Enable the Client Setting Enable Wholesale Options in Manage Orders Action Menu in Settings > Client Settings > General Client Settings. This will add the Generate Statement of Account options (PDF and Excel) in the Action menu of the Manage Orders page.
Go to Orders > Manage Orders > Select an order or orders.
From the Action menu, select Generate Statement of Account (PDF or Excel) to download the statement.
Open the downloaded report.
Below are examples showing a sample invoice for each report type.
PDF version — Shows each customer’s invoice on its own page (or pages, based on the number of invoices):
Excel version — Shows a list of running rows for each customer invoice:
The table below lists and defines each of the columns in the statement.
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
The customer’s first name.
Last Name
The customer’s last name.
Email
The customer’s email address.
Phone
The customer’s phone number.
Invoice Date
The 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
The date that the invoiced amount is due.
Invoice Amount
The total amount of the invoice.
Balance Due
The total amount that is owed on the invoice.
Running Balance
Previous balance (if any) plus the current balance.
0-30 Days
31-60 Days
61-90 Days
90+ Days
Days after the invoice due date.
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.
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
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:
PDF version— This shows each customer’s invoice on their own page (or pages, based on their number of invoices):
Excel version— This shows a list of running rows per customer invoice:
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.
Email
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.
The Export Orders page has an Export Statement of Account option in theExport via Plugin dropdown field to export a generated statement of account (requires the client setting Enable Wholesale Options in Manage Orders Action Menu).
