We’ve redesigned the ConnectBooks P&L report to make it easier to understand and more informative. Here's a summary of what's changed and why.
What the Old Report Looked Like
In the previous version of the report, the layout often led to confusion:
A column called Quantity showed the net quantity of items that came out of inventory.
Gross Sales showed the net sales (after refunds and adjustments).
Two separate columns—Merchant Fees and Other Fees—displayed related charges but weren't always clear.
What’s Changed in the New Report
We’ve made several improvements to give users better visibility into their numbers:
1. Clear Separation of Sales and Refunds
Instead of showing just “quantity” and “gross sales,” we now display:
Sales Quantity
Refund Quantity
Sales Amount
Refund Amount
This helps you see both the number of items and the dollar value for sales and refunds separately.
2. Simplified Fees Column
Instead of two separate fee columns, we now show one unified Fees column. This gives you the total of all fees in one place, making it easier to understand your true costs.
3. Improved Item Details View
Clicking the + symbol next to an item now reveals a clearer, more organized breakdown of the details:
Financial Transactions: Lists sales, refunds, and adjustments from a financial perspective (e.g., 10 refunds).
COGS Transaction: Shows how many units actually affected inventory (e.g. Returned 7, only 7 of the 10 refunds were returned to inventory).
This helps explain why numbers may differ between financial records and inventory.
4. Renamed and Optional Columns
Some columns were renamed for clarity and moved to the column chooser:
Gross Sales is now Net Sales (available in the column chooser).
Quantity is now Total Units (also in the column chooser).
Both are hidden by default, but you can add them back if needed.
We also clarified the naming throughout the report:
Columns labeled “Qty” represent the financial quantity, for example, if you issued 10 refunds, that would appear under the Refund Qty column.
Columns labeled “Units” reflect the actual impact on inventory, for instance, if only 7 of those 10 refunded items were returned to inventory, they would show under the Returned Units column.
This naming makes it easier to understand how many items were financially processed versus how many actually affected your inventory.
5. Customize Your View
Prefer the old format? You can recreate it by customizing your template:
Add Total Units and Net Sales as your first two columns.
Turn off the new detailed columns.
Save it as your default template.
Need more time to adjust?
For the next 30 days, you can still access the old report layout at old.connectbooks.com
These changes were made to bring more clarity and flexibility to the report, helping you better understand your sales, refunds, and fees at a glance.