Skip to main content
All CollectionsAccounting
How do I create a Customer Revenue Report?
How do I create a Customer Revenue Report?
Updated over 6 months ago

You may want to create a report of your Inventory's revenue over a certain time frame. In order to do so, please follow the below steps.

  1. Select Analytics from the left hand side.

  2. Press "View Ledger" in the top right hand corner.

  3. Download the Ledger using "Export" in the top right hand corner and select the dates you are interested in seeing.

  4. In Excel or Google Sheets, select all of the data and in the menu select "Create Pivot Table."

  5. Add "Customer" to Rows, "Account" to Columns, and "Debit" to Values.

This will allow for you to see the amount break down per account for each customer.

Disregard the "Grand Total" column. The amount you can expect to be paid out will be listed under Accounts Receivable

Did this answer your question?