Hello, I am looking for a report that shows Client Name with sales say item 4023 shown monthly. Any help?
Hi @Sabhunu
There isn’t such a report at the moment I’m afraid. You can view monthly breakdowns by nominal code, and you can view total invoiced/received by client, but not income on a nominal by client.
How can I create one such report as I need it for management reporting?
There’s no way of doing this within QuickFile itself - it’s just not possible to view the nominal entries for a specific code, grouped by clients. You can however generate a report for a single nominal code, or a range of nominal codes using custom reports - but this wouldn’t be limited to specific clients, or list them.
You could in theory export the nominal activity from the Chart of Accounts, which would give you a .csv file. This wouldn’t list the clients, but may include the client name in the “Notes” column.
The other option may be to use the API, but this would involve checking each invoice for the nominal codes used.
This is doable in Excel from the CSV files in an account backup, but it’s a bit fiddly since the nominal codes and amounts are in one file (Sales_Invoice_Items.csv) but the client names and invoice dates are in another (Sales_Invoice.csv). You’d have to do a VLOOKUP on the invoice ID to bring the client name and date columns into the “items” sheet, then do a Pivot Table with the months as column headers, client name and nominal as two levels of row headers, and the amount as values.
This topic was automatically closed after 7 days. New replies are no longer allowed.