The Items Accounting Flow Report answers how each item moved in a period, as an accountant reads it: the stock at the start, the purchases, returns to suppliers, sales, returns from customers and the other movements, and the stock at the end, each with its quantity, average price and amount at purchase prices. Open it from Reports → Items → Items Accounting Flow….
Filter
The Items Accounting Flow Report window opens first. Fill in only the filters you need: an empty filter does not limit the report. Click OK to run the report. Clear empties the filters and sets the check boxes back to their default. The window keeps the last filter you ran.

The check box in front of a filter puts its column in the result. A cleared check box also adds the rows up over that column: with Location: and Location group: cleared, the movements of an item in all locations make one row. With Item code:, Item name:, Barcode: and Catalogue: cleared, all items of a location make one row, or of an item group when Item group: is selected. A text filter finds the values that contain the text. Press F4 or click … to choose from a list.
| Filter | What it limits | Column by default |
|---|---|---|
| Date: | The period, by the date of the documents. Choose a period from the list, or Custom Dates and a start and an end date. Without a start date the period starts with the first document, without an end date it ends today. | No column |
| Item code:, Item name: | The items. | Shown |
| Barcode:, Catalogue: | The items by barcode or catalogue number. Each adds three columns. | Not shown |
| Item group: | The items of a group. | Shown |
| Location:, Location group: | The locations. | Shown |
| Item tag:, Location tag: | Listed when such tags exist. They only filter. | No column |
| Lot:, Serial number:, Production date:, Expiration date:, Lot location: | Listed when you work with lots. A shown lot column splits the rows by lot. | Not shown |
Results
The result opens in its own tab. The example below has one location in Location: and the last ten days in Date:, with Barcode:, Catalogue:, Item group:, Location: and Location group: cleared, so each item has one row. Measure, the price columns and the columns of the returns, income and expense are hidden with View, so the amounts fit on the screen.

| Column | What it shows |
|---|---|
| Code, Item, Barcode 1 to 3, Catalogue 1 to 3, Measure, Item Group | The item, as it is now in Items. Quantities are in this Measure. |
| Location, Location Group | The location. |
| Beginning Qtty, Beginning Price, Beginning Amount | The stock before the start date, its value at purchase prices and the average price, the amount divided by the quantity. |
| Purchase Qtty, Purchase Price, Purchase Amount | The purchases of the period. |
| Returned to Supplier Qtty, Returned to Supplier Price, Returned to Supplier Amount | The returns to suppliers of the period. |
| Sale Qtty, Sale Cost, Sale Price | The sales and consignment sales of the period, with their average purchase price and average sale price. |
| Sale Cost Amount, Sale Amount | The same sales at purchase prices and at sale prices. |
| Returned Qtty, Returned Price, Returned Amount | The returns from customers of the period, at purchase prices. |
| Income Qtty, Income Price, Income Amount | The other documents that bring items in: stock-takings, transfers into the location, consignment returns, products of productions and credit notes. A stock-taking counts with its difference, negative for a shortage. |
| Expense Qtty, Expense Price, Expense Amount | The other documents that take items out: wastes, transfers out of the location, write-offs, ingredients of productions and debit notes. |
| Ending Qtty, Ending Price, Ending Amount | The stock at the end date, its value at purchase prices and the average price. |
| Profit | Sale prices minus purchase prices of the sales, consignment sales and debit notes, from the first document up to the end date. The start date does not limit this column. |
How the numbers are counted
- The report counts saved documents. Drafts and documents still pending in another database are left out. An annulled document no longer exists, so it is not counted.
- A document counts on its Date, the date of the document, not on the day it was saved or edited.
- Beginning Qtty and Ending Qtty add up every document that changes the stock, consignments too. A consignment has no column of the period: its goods count in Sale Qtty when the consignee sells them and in Income Qtty when they come back.
- Each document row counts at its own purchase price, the one saved with the document, and at its sale price after the discount. The amounts and prices are without VAT: with Use prices with included VAT in Tools → Settings… → Special the VAT is taken out of them.
- An average price is 0 when its quantity is 0.
- The report lists the items that have documents up to the end date, also services and deleted items.
- Amounts are in the main currency of the program.
Work with the results
Document opens the print preview of the result with its filters, and Export saves it to a file. Totals adds a row with the totals of the quantity and amount columns. View shows the result as bars or a pie (see View Report Results). Filter → Report Filter shows the filters next to the result and runs it again as you change them, Report Filter as New… opens the result of another filter in a new tab, and Quick Filter searches the text of the rows. Refresh runs the report again. The report can also be a panel of the Dashboard.
When an item column is shown, double-click a row or use Actions → Edit to open its item. Actions → Transform Selected Items puts the selected items in a new document (see Transform Document). Actions → Print Selected Items prints their labels when a quick print setup of Print Barcodes exists. When the item columns are cleared and Location is shown, double-click opens the location.
Permissions
All permissions are set in Edit → Administration → Permissions….
| Permission | What it allows | Not allowed by default for |
|---|---|---|
| Reports → Items → Items Accounting Flow… | The report. | Operators (the whole Reports menu) |
A user with a Locked location: in the user’s settings gets that location fixed in the filter. With Show items purchase price cleared there, the user does not see Purchase Amount and Profit, and with Show items profit cleared not Profit.
FAQ
Why do the beginning and the movements not add up to the ending?
Goods still on consignment at the end date have left the stock, but they are not yet in Sale Qtty or Income Qtty. Without consignments, Beginning Qtty + Purchase Qtty − Returned to Supplier Qtty − Sale Qtty + Returned Qtty + Income Qtty − Expense Qtty gives Ending Qtty.
Why is Profit larger than the sales of the period?
Profit counts all sales up to the end date. For the profit of a period use Profit by Items.
How do I see one total for a location?
Clear Item code:, Item name:, Barcode:, Catalogue: and Item group:, and keep Location:. The amount columns then add up all items of each location.