The income analysis is a quick report to help you track your net revenue by product-enterprise categories.
💡 NOTE
Income Analysis is commonly used to create routine journal entries within your accounting software (e.g. Quickbooks, etc) to track net revenue by product categories, and sales channel.
Income Analysis Report Overview
The Income Analysis Report in GrazeCart is a valuable tool designed to help you quickly analyze your revenue by major product categories, regardless of how products are grouped in your collections. It also provides useful data for accounting and revenue tracking in software like QuickBooks or similar platforms.
Key Features & Functions
-
Revenue Breakdown by Product Category:
The report groups your sales data by the Accounting Class ID assigned to each product. This ID acts like an income account category (e.g. Beef, Chicken, Dairy) and makes it easier to track and report revenue accurately for accounting purposes. -
Automatic Data Filtering:
By default, the report shows:-
Orders with a payment date within the last 30 days (This is the maximum timeframe for this report)
-
All order statuses
-
-
Summarized Revenue & Weight:
It displays total weight and revenue for each accounting class, including delivery or miscellaneous fee income. -
‘Null’ Category Notice:
Any products missing an Accounting Class ID will appear under a “null” category. This is a helpful indicator for correcting incomplete data assignments.
Deductions Included
The report also accounts for:
-
Discounts
-
Customer credits and gift cards
-
Coupon redemptions
-
Sales tax
-
Subscription savings
These deductions are subtracted from your gross revenue to display a net revenue total — the actual amount you’ve earned through GrazeCart after adjustments.
For Accounting & QuickBooks Users
-
Use this report to create journal entries for revenue in your accounting software.
-
Note:
-
This report does not include payment gateway fees (like credit card processing fees) or refunds issued after a transaction is marked paid in GrazeCart. You’ll need to gather that data directly from your payment gateway’s reporting tools.
-
-
Quick Tip for Reconciliation:
Use the Payment Method filter and adjust the Payment Date range to match specific deposits in your bank account for easier reconciliation.
Where to Assign Accounting Class IDs
-
Inside any product, under the Settings tab
-
Or quickly assign/edit them using the Inventory index page’s Quick Edit menu
This ensures your report data remains accurate and complete.