Step 1: Enable Analytic Accounting
First, we need to ensure that analytic accounting is properly enabled:
- Navigate to Accounting → Configuration → Settings
- Under the Analytics section, make sure the following options are enabled:
- Analytic Accounting (check this box)

- Click Save to apply your changes
Step 2: Create an Analytic Plan for Gross Receipt Revenue
Now, let's create a dedicated analytic plan for tracking revenue by state:
- Go to Accounting → Configuration → Analytic Plans
- Click New
- Fill in the details:
- Name: Gross Receipts Revenue

- Click Save
Step 3: Create Analytic Accounts for Each State
Next, we'll create analytic accounts for each state where you do business:
- Navigate to Accounting → Configuration → Analytic Accounts
- Click New
- For the first state, enter:
- Name: Delaware
- Plan: Gross Receipt Revenue (select from dropdown)

- Click Save
- Repeat steps 2-4 for each additional state:
Step 4: Create Sample Customer Invoices with State Analytics
Now let's create some sample invoices to demonstrate how this works:
- Navigate to Accounting → Customers → Invoices
- Click Create
- Enter the customer information
- Add invoice lines (products/services)
- For each invoice line, click on the line to expand details
- Under the Analytic tab, select the appropriate state from the Gross Receipts Revenue dropdown:
- For applicable Michigan revenue, select "Michigan"
- For applicable Nevada revenue, select "Nevada"
- And so on
- Complete the invoice and click Confirm

Repeat this process to invoices applicable across different states.
Step 5: Validate and Post Invoices
To ensure your data is properly recorded:
- From your invoice list, make sure all invoices are in "Posted" status
- If not, select each draft invoice and click Confirm
- Verify that the correct analytic account (state) is assigned to each invoice
Step 6: Generate Profit and Loss Report Filtered by State
Now for the exciting part - seeing your revenue broken down by state:
- Navigate to Accounting → Reporting → Management → Profit and Loss
- Click on Filters
- In the Analytic section, click Add filter
- Select the states you want to analyze (e.g., Delaware, Michigan, etc.)
- Click Apply

Your Profit and Loss report will now show revenue filtered by the selected states. You can compare states side by side by:
- Click on Comparison
- Select Analytic for comparison type
- Select multiple states to compare
- Click Apply
Dealing with Refunds and Credit Notes
When processing refunds:
- Ensure the credit note uses the same analytic account as the original invoice
- Verify that your reports correctly offset refunds against revenue
- Create a test credit note to confirm proper reporting
Troubleshooting Common Issues
Missing Analytic Data
If you notice revenue without state assignment:
- Navigate to Accounting → Accounting → Journal Items
- Filter for revenue accounts
- Look for entries without analytic accounts
- Add analytics through journal items if necessary

Inconsistent Reporting
If your reports show unexpected numbers:
- Check for invoices spanning multiple periods
- Verify the date filters on your reports
- Ensure refunds and credit notes are properly accounted for
Multiple State Allocations
For services that span multiple states:
- Create split invoice lines
- Assign appropriate percentage to each state
- Document your allocation methodology
With this analytic accounting approach, you can easily track revenue by state for Gross Receipts Tax compliance. The system is flexible enough to handle various business models and tax requirements while providing the accurate data you need for revenue reporting.
Have you implemented a similar solution or have questions about this approach? I'd love to hear your thoughts and experiences in the comments below!
**Note: While this guide provides a technical approach to tracking state revenue, please consult with a tax professional to ensure your specific implementation meets all regulatory requirements for your business.