Last modified: September 12, 2025
Account activity and balance report
Providers
This report is available to practitioner seller accounts (profit accounts) and can be downloaded from the Reports page after your first successful payout.
This handy report can be downloaded for any tax year to assist with general accounting, staff payouts, and tax filing.
Tip!
Dispensary owners will always have access to view and download dispensary reports. Access can be extended to additional practitioners and staff from the Permissions tab in Dispensary Settings.
What data does this report capture?
This report is a running balance of dispensary sales activity. Through this running total, Net Sales, Cost of Sales (a.k.a. Cost of goods sold, or COGS), and Net Income can be calculated.
Tip!
Download the Excel (.xlsx) file to have Net sales, Cost of Sales, and Net income calculated automatically at the bottom of the report.
Downloading the report
This report, and other financial reports, are only available after your first successful payout.
To download the account activity and balance report:
- Click the Analytics tab.
- Click View financial reports.
- Scroll to the Account Activity and Balance Report heading.
- Use the dropdown menus to select a Year and a format to Download as.
- Click Download.
Your report will download to your device in your preferred file format.
Tip!
Select the AABR 2020 v – US (with labels).png attachment at the bottom of the article to enlarge this image.
Activity summary
The account activity and balance report summary is a snapshot of your sales activity.
To view this activity summary, go to the Financial reports page and select a year.
The account activity and balance report summary displayed on the Financial reports page.
Net income
Net income is calculated as Net sales (sum of sales_total column) less Cost of sales (sum of cogs_total column).
Tip!
In the 1099-K Export report, a reconciliation of a dispensary’s 1099-K amount (gross volume) to net income is presented at the bottom of the report. This net income figure is expected to align with the net income calculation in the AABR.
Net sales
Net sales are the sum of your gross sales minus returns, allowances, and discounts.
Cost of sales
Cost of sales represents product cost and fees earned by Fullscript associated with administering the transaction. Also referred to as cost of goods sold (COGS).
Transactions found in the report
Shipments
Shipment rows represent successful or canceled shipments. All order activity is appended to the report at the time of an order’s first shipped shipment (including all earnings). Canceled shipment rows will generate for any products removed from the order after the first shipment (i.e., backorder cancellations).
Payouts
Payout rows reflect successful payouts.
Payouts appear as a negative value in the total column to withdraw from the dispensary’s available balance.
Refunds
Refund rows are refunds that stem from product returns.
Refunds adjust the balance by negating appropriate columns: msrp_total, patient_discount (if applicable), sales_total, cogs_total, subtotal, and total.
Custom fees
For lab orders, custom fees appear with a 0.00 balance under msrp_total, patient_discount, and cogs_total. The sales_total column shows the earnings from the custom fee.
Report column headings and descriptions
Descriptions of headings found in the account activity and balance report have been provided below to help navigate the report.
| Column headings | Description |
|---|---|
| transaction_number |
The shipment ID. (i.e., H95998906904) |
| transaction_type |
The row’s record type. i.e., payout, refund, or shipment. |
| transaction_status |
The transaction record’s status. i.e., amounts paid (payouts), shipped (orders), or received (refunds). |
| order_number |
Fullscript order number. (i.e., R111222333) |
| transaction_date |
The date the shipment shipped; the date the refund was received; the date the payout was paid. |
| msrp_total | Total MSRP (retail price) of the shipment. |
| sales_total |
Represents the total retail cost and is calculated as the msrp_total less the patient_discount. The sum of this column equals Net Sales. |
| patient_discount |
The total discount ($) the patient received on the order. |
| cogs_total |
The fee earned by Fullscript representing product cost and fees associated with administering the transaction. The sum of this column equals Cost of Sales (or cost of goods sold). |
| total |
Represents Net Earnings from the transaction and is calculated as the sales_total less cogs_total in the US report. Note: This is the ‘amount’ column in exports for previous years (2019 and earlier). |
| balance |
Running balance of funds available for payout. |
Additional columns – Canadian reporting only
Canadian reporting has additional columns to accommodate accounts that have opted-in to collect tax on their payouts.
Note:
These columns are only found in the current version of the account activity and balance report. In previous years (2019 and earlier), hst collected from payouts generated hst rows in the report.
| Column headings | Description |
|---|---|
|
subtotal (Canada only) |
Represents the order’s net earnings to be paid before HST and is calculated as sales_total less cogs_total. |
| hst (Canada only) |
HST paid (appended to payout) if the customer provided their business number to collect HST on payouts. |
| total |
Represents net earnings from the transaction and is calculated as sales_total less cogs_total plus hst in the CAN report. Note: This is the ‘amount’ column in exports for previous years (2019 and earlier). |
