How to create a report that shows sales per customer with a year-on-year comparison

1. Navigate to Reports > Financial > Comparative Income Statement > Customize
2. Edit Columns > Add Budget and Financial: Customer/Job: Name
3. Set Comparative Amount: Alternate Date Range = last fiscal year (e.g., 2020)
4. Set Filters > Budget and Financial: Account (Line): Name equal to Revenue or Sales (or whatever account is used in recording sales). Add.
5. Set Budget and Financial: Date: Enter From and To Dates. Click Done
6. Click Preview

Leave a comment

Your email address will not be published. Required fields are marked *