How it works
When you run a P&L report, you see a dropdown next to the store filter called Files. It lets you choose from your inventory files. Under each file there are 2 options:
Adjustments: inventory changes you recorded
Customers: invoices you created in ConnectStock
Choose what you want to include, and it shows up in the report.
Invoices
Each invoice has a toggle called Include in P&L Report. Turn it on to include that sale in the P&L for that customer. You can also filter the report by customer, so you can run it for 1 customer (for example, John Smith) or for all customers at once.
Adjustments
Adjustments also have a toggle to include them in the report or leave them out. Use it to control what affects your P&L. For example, beginning inventory or onboarding adjustments should stay off. Day to day shrink or write offs should be on if you want them in the report.
Fees, discounts and service items
When you add a service item (like a fee or a discount) to an invoice, you have 2 ways to show it on the report:
Separate line: the fee shows as its own line with the service item name.
Allocate to items: if you turn on Allocate fee to items, the amount is split across the units of the inventory items on the invoice. It shows as a fee on each item sale, like discounts or FBA fees.
On each service item, use the Report Column field to choose where it shows in the P&L report: Merchant Fee, Other Fee, Advertising or Income. To leave it out of the report, turn off Include in P&L Report on the item.
The data shows on the reports on the same date as the original invoice or adjustment.
Frequently asked questions
Why doesn't my adjustment show in the P&L?
Check that its Include in P&L Report toggle is on, and that Adjustments is selected under the file in the Files dropdown.
How do I keep a service item out of the P&L?
Open the service item and turn off Include in P&L Report.