Sellercloud Help
  • Home
  • Support
  • Product Updates
  • Sellercloud.com
  • Help Ecosystem
    • For Developers
    • Skublox Help
    • Skustack Help
  • Request Demo
  1. Home
  2. General
  3. Customers
  4. Wholesale Customers
  5. Statement of Account
Searching...

Statement of Account

  • Created August 10, 2020
  • Updated date January 19, 2023
  • Author Ignat.k
  • Category Wholesale Customers
  • Views: 2423
  • 0

Overview

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.
  1. Go to Orders > Manage Orders > Select an order or orders.
  2. From the Action menu, select Generate Statement of Account (PDF or Excel) to download the statement.
  3. Open the downloaded report.
  4. Below are examples showing a sample invoice for each report type.
    1. PDF version — Shows each customer’s invoice on its own page (or pages, based on the number of invoices):Invoice PDF
    2. Excel version — Shows a list of running rows for each customer invoice:
      Invoice Excel

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.


Overview

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:

  1. Click Orders > Search for orders > Select desired orders > click Action Menu > Generate Statement of Account (PDF or Excel) > Go.
  2. Click the downloaded report to open it. Check out a sample statement showing a single invoice from a whole report:
    1. PDF version— This shows each customer’s invoice on their own page (or pages, based on their number of invoices):
    2. 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 the Export via Plugin dropdown field to export a generated statement of account (requires the client setting Enable Wholesale Options in Manage Orders Action Menu).

Tagged: account reportaccount statementaging reportbilling statementcustomer account statementorders statementstatement of account

Was this article helpful?

Yes No
Need Support?
Can't find the answer you're looking for?
Contact Support

Table of Contents

  • Overview
  • Create a Statement of Accounts
  • Overview
  • Creating statement of accounts

Related Articles

  • Customer Accounts Configuration
  • Configure Wholesale Customers
  • Gift Cards
  • Customer Management Overview
  • Third-Party Billing to Wholesale Customer Account
  • Merge Customers

Need Support?

Can't find the answer you're looking for?
Contact Support
© Copyright Sellercloud 2023

We are using cookies to give you the best experience on our website.

You can find out more about which cookies we are using or switch them off in .

Privacy Overview
Sellercloud

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookies

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

Show details
Name Provider Purpose Expiration
moove_gdpr_popup Moove Agency to store visitors decision to accept or decline cookies 365 days
3rd Party Cookies

This website uses Google Analytics to collect anonymous information such as the number of visitors to the site, and the most popular pages.

Keeping this cookie enabled helps us to improve our website.

Please enable Strictly Necessary Cookies first so that we can save your preferences!

Show details
Name Provider Purpose Expiration
_ga* Google Analytics to store and count pageviews 1 year
_gid Google Analytics to store and count pageviews 1 day