The standard reports in each area
The ERP comes with the reports of the Powergest Desktop ERP as standard, with the same title, columns and ranges. This page tells you which ones there are in each area besides the usual ones (invoices, delivery notes, instalments) and what each one gives you. They are all run from their area’s reports page or from Reports → Reports, and the ones that aren’t in the page’s menu appear in More reports.
Which customer reports are there besides the invoice and delivery note ones?
In Customers → Customer reports:
- Delivery notes and outstanding balance: each customer’s delivery notes with their amount, VAT, discount, expenses, total and what was collected on the delivery note itself. With the Status range set to ‘Confirmed / pending invoicing’, only the ones still to be invoiced appear. The Desktop ERP’s ‘Account total’ (the customer’s accounting balance added to the delivery notes) doesn’t appear in this report: the balance is on the customer statement.
- Route assignment by customer: each customer with the code and name of their route, their order within it, address and phone, sorted by route and order. The route is changed on the customer record.
- Delivery routes report: the routes with the sales agent who covers each one.
- Trades report: the trades with their description.
- Documents by customer type report: the sales documents with their date, customer, town / city and total, grouped by customer type and, within that, by sales agent. Ranges for date, number, customer, sales agent and customer type.
- Carriers by customer: customers grouped by their usual carrier, with the carrier’s code and name.
- Vehicles report: the customers’ vehicles with their customer, dates, mileage and prices.
- Documents by vehicle (in sales): the documents that have a vehicle, with registration number, chassis number and amounts; sorted by registration, chassis number, date or customer.
- Invoices by carrier (in sales): invoices grouped by the carrier of each one, with amount, discount, total and what was collected. The Collected only tick box leaves those with nothing outstanding.
- Issued cheques report (in purchases): the supplier invoices paid by cheque, with its number, the total, what was paid and what is outstanding.
- Phone directory: name, contact, address, phone, mobile and email of all records (customers, suppliers, sales agents), with ranges by name, contact, address, postcode, province and phone.
- Points by customer report: each customer’s points, the points spent and the balance, as they are on their record.
- Customer types report: the types master with their discount and sales agent.
- Mailing to records: which customers each marketing send from mailing reached and what happened: their email, when it went out, its status, whether they opened it, whether they clicked a link, whether it bounced, and which send and campaign it was. At the foot, how many opened it, clicked and bounced, and the open and click rates over those it reached (the same figures as Mailing → Metrics). Ranges for send date, customer and send number, and What happened (sent, opened, clicked, bounced or not sent).
- Documents sent by email: the emails from mailing’s document sending, each one with its document, the customer, the address, when it went out, its status and whether it was opened; emails that grouped several documents for one customer list them underneath. Ranges for send date, customer and What happened.
Which sales agent reports are there?
In Customers → Sales agent reports:
- Customers by sales agent (sales for the period): one line per customer of each sales agent with what was sold (credit notes subtract), the total and what is outstanding, and the sales agent’s total; each sales agent starts on a new sheet. The sales agent is the one on each invoice.
- Customers by sales agent: the record of each sales agent’s customers (address, town / city, province, phone and contact). In Subtotals by you choose whether to break by sales agent or by province.
- Customers by sales agent (record and status) and Customers by sales agent · credit risk: the same record with the customer’s status, or with their credit limit, risk, discount and scheme.
- Profit summary by sales agent: by sales agent, credit notes, net sales, cost, profit, its percentage on cost, the total and what was paid.
- Workers report: the workers with their cost per hour.
Which sales reports are there for checking the till and analysing what was sold?
In Sales → Sales reports:
- Sales invoices (payment summary): each invoice with what was collected as immediate payment, by card, deferred and outstanding, by month. It has a Cash range.
- Daily sales invoice summary: one line per day with the tax base, the VAT, the expenses and the breakdown of the receipt, and the total for each month.
- Outbound detail: each line that took goods out (delivery notes, direct invoices and credit notes), with totals by the break you choose in Subtotals by. An invoice made from a delivery note isn’t counted: the goods were taken out by the delivery note.
- Outbound detail by item, by customer and item and by family: the same outbound movements summarised, with units, average price and total. Credit notes subtract.
- Outbound detail with tax bases and VAT: each line with its VAT rate and, at the foot, the tax base and the tax amount at 21, 10 and 4 %.
- Profit detail by item: average purchase and sales price, units, total and per-unit profit, and its percentage.
- In the Management reports group, the eight in the Desktop ERP menu of the same name:
- Profitability analysis by product, by sales agent and by customer: units, average price, amount, cost, profit and its percentage for each item. By sales agent and by customer are the same analysis with a subtotal per sales agent or per customer.
- Profitability summary by customer: the same, in one line per customer.
- Sales analysis, by sales agent and by customer: what was sold of each item in the period against the financial year.
- Sales summary by customer: the same, in one line per customer.
The profit percentage is calculated as the company sets in Warehouse price calculation: on cost or on sales. The sales agent is the one on the invoice.
- Sales orders and Sales orders by date: each order with its delivery date, whether it has been delivered (and with which delivery note), the units ordered and delivered, and the amounts, by month. The Pending delivery tick box leaves those with something still to be delivered.
Where are the issued invoices?
In the Invoicing group, the same one purchases have and in the same place:
- Issued invoices: the issued invoices book, one line per invoice with the tax base and the VAT broken down by rate (21, 10, 4 %…), the exempt amount and the surcharge. It is the same one that appears in VAT management reports → Issued invoice list → Sorted by date.
- Issued invoice list: one line per invoice with the tax base, the VAT, the surcharge, the expenses and the total, with the total for each month.
If your user can’t see the VAT reports, you won’t get the first one.
The cost of a sale is the one recorded on the line when it is sold. The cost and profit columns come out right for what was sold with a recorded cost; a line with no cost counts as profit in full.
Which purchase reports are there?
In Purchases → Purchase reports:
- Purchase orders and Purchase orders by date: the mirror of the sales ones, on the supplier.
- Purchase invoices (payment summary): each invoice with what was paid as immediate payment, by card, deferred and outstanding.
- Inbound detail by item and by supplier and item: the units that came in, their average price and the total. Goods receipts and direct invoices count; the invoice that includes a goods receipt isn’t counted, and credit notes subtract.
- Import invoices by supplier: the import book with the total for each supplier.
Where do I see received invoices with the VAT for each rate?
In the Invoicing group:
- Received invoices: the received invoices book, one line per invoice with the tax base and the VAT broken down by rate, the exempt amount and the surcharge, and the supplier’s invoice number. It is the same one that appears in VAT management reports → Received invoice list → Sorted by date.
- Received invoice list: one line per invoice with the tax base, the VAT and the surcharge in a column each, the expenses and the total, with the total for each month.
Sales have the same group with the issued ones.
Where are the IRPF withholdings?
On the VAT management reports page: Withholding tax (IRPF) on sales and Withholding tax (IRPF) on purchases, one line per invoice with withholding, with the tax base and the withholding (credit notes subtract) and the total for each month or quarter.
Which receipt and cash reports are there?
On the Receipt reports page:
- Cash receipts summary: each document with what was collected as immediate payment, by card, deferred and outstanding, and the total for each day.
- Issued cash counts (cash control): each cash count with its opening balance, incoming, outgoing, balance, count and discrepancy, by till.
- Bill issue: the pending instalments with the customer’s bank account and the number of bills. Payment reports has the one for suppliers.
- Report by payment date: the bills collected, by the day they were collected, with the account and the operation that collected them. A returned bill doesn’t appear. In Payment reports, what was paid to suppliers.
- Direct debit batch issue report: the instalments each direct debit batch collected, with the customer’s IBAN and Tax ID (NIF) and what was collected.
- Deferred receipts: what was collected in the period on invoices from previous days, split between cash, card and bank according to the treasury account it was collected into.
- Receipts on orders: customers’ advance payments linked to a document, with what was collected in cash or by card, what was applied and what is still left on the document.
In the splits between cash and card, what decides is the treasury account the immediate payment was collected into: a receipt taken partly in cash and partly by card appears in full in one of the two.
How do I get the movements of a till, a bank or a card?
In Treasury → Receipt reports, group Treasury reports, as in the Desktop ERP: Till movements, Bank movements and Credit card movements. The same group has the account lists: List of till accounts, of bank accounts and of credit card accounts.
Each statement comes from the ledger of the till’s, bank’s or card’s accounting account: everything posted to it, whether from a receipt, a payment, an invoice or a manual journal entry. For each account:
- a first Previous balance line with what came in and went out before the «from» date, counted from the start of the financial year, and its balance. If there was nothing before, it does not appear;
- one line per entry, with the date, the document, the third party, the description, the incoming (debit) and the outgoing (credit), and the running balance from the previous one. The receipt or payment of instalments shows one line per instalment, as in the desktop ERP: its invoice, the customer or supplier and «Cobro Rec. 000126». A cash payment shows its invoice and its customer. A receipt with charges, with overpayment or settled with advances or vouchers shows as a single line with the receipt number;
- the total for each month and for the account, with its incoming, outgoing and balance (incoming minus outgoing). The previous balance counts in them, as in the desktop ERP. In the till one, Subtotals by: Day gives the total for each day instead of each month.
In the dialog you narrow it down by account (with the treasury accounts magnifier), date and document.
A till, bank or card without an accounting account in its record doesn’t appear: it has no ledger to come from. You set it in its treasury account record.
Which reports are there for what is owed to suppliers?
They are the same instalment reports as the receipt ones: in their dialog, Open items chooses Receipts or Payments, as in the Desktop ERP, and the labels change with it (‘Supplier’ and ‘Paid’ instead of ‘Customer’ and ‘Collected’). In Treasury → Payment reports they open with Payments already chosen:
- Report by supplier and invoice and by supplier and instalment: grouped by supplier.
- Report by due date: what is due to be paid, in date order, with subtotals by month.
- Report by invoice number and by invoice date.
- Report by payment date: what was paid, by the day of payment.
- Bill issue: the bills pending payment with the supplier’s bank account.
- Outstanding payments analysis: one line per supplier with what is owed to them, split into age bands.
They are narrowed by supplier (the customer range isn’t used in payments), invoice date, invoice number, due date, bank, payment method, status and currency. The Outstanding column only counts the instalments that are still pending: one already paid comes out at zero.
Which accounting reports are there?
In Accounting → Accounting reports, grouped as in the desktop accounting programme:
- Journal: Journal by journal line (in journal entry order; in Subtotals by you can separate each journal entry or each month), Journal by month (with the total for each month), Full journal (each journal entry with its header, the business partner’s Tax ID (NIF) and its total) and Summary journal (what each account moved, at 3-digit level and with the total for each 2-digit group).
- General ledger: General ledger by date (each account with its balance before the ‘from’ date, the running balance and the total for each month), General ledger by invoice (sorted by document), Full general ledger and Business partner transactions.
- Accounts: the Chart of accounts (by level and with the text the title has to contain), the Annual balances and the Monthly balances for a period, for one month or cumulative up to a month, and the Transformation report, which shows the code each account had in the previous chart.
- Trial balance: the Annual report, the one for a period, the one for one month, the one cumulative up to a month and the one with Separate opening balance, which puts in its own column what the opening journal entry brought.
- Annual accounts: the Balance sheet and Profit and loss. These two don’t open a dialog like the others: they take you to the annual accounts screen, each with its report already chosen, which is where they are calculated with the items you have defined. They are in this list because this is where people look for them, next to the journal and the general ledger.
- Journal check: the Imbalance report (journal entries whose debit doesn’t equal their credit, with their journal lines) and the Journal entry check, which tells you what is wrong with each journal entry: no journal lines, imbalance, journal line to a group account, zero amount, date outside its financial year, no description (neither on the journal entry nor on any of its journal lines) or after a gap in the numbering (‘Journal entry 6 is missing’, ‘Journal entries 8–9 are missing’). The gap is looked for across the whole financial year, even if you only ask for one month. Each journal entry comes out with a single issue, the first one in that list.
- Cost centres (if you have cost accounting): the list of departments and projects, their annual and monthly balances, and the Cost accounting balance by centre and account or by account and centre. If the company has no centre and no allocation, instead of ‘No results’ they say The company has no cost centres and no analytical allocations.
They all open with the active financial year: dates from its start to today, months from January to the current month and accounts from the first to the last.
How do I get the balance at group level?
In Accounts at level you choose how many digits each line has: with ‘2 digits’, the line ‘43 Customers’ adds up all the sub-accounts starting with 43. Empty, one line per sub-account. In Totalled at level you choose the group that has its own total, with its name (‘Total 43 Customers’); it opens at 2 digits, like the Desktop ERP.
What doesn’t the balance filter that the Desktop ERP did?
- Accounts with no balance, Balances greater than and Amounts greater than: they look at the account total and aren’t offered here. An account with no movements in the period never appears.
- Matched journal lines (matching) and Currency: they aren’t offered in any accounting report.
- In the General ledger by invoice, the counterpart range: the journal line doesn’t store its counterpart.
- Closing journal entries (regularisation, profit and loss and closing) don’t go into the balances or the balance sheet, just as on the trial balance screen: a closed financial year doesn’t come out at zero.
The Desktop ERP’s Cost accounting journal isn’t a report: you look it up in Cost accounting → Cost journal.
Which warehouse reports are there?
In Reports → Reports, in the Warehouse tab:
- Warehouse stock movements: one line per warehouse document —incoming, outgoing or inventory— with its warehouse, the units and the amount, by month. One line per movement of each item is given by Detailed warehouse movements, which, for an item with sizes, gives the size and colour moved next to its description: ‘t-shirt · S · Blue’.
- Warehouse inventories and Warehouse inventory detail: the inventories, summarised or with their lines.
- Detailed work orders: each order with its lines.
- Stock movements of items without batches: incoming or outgoing movements of items that use batches and were made without a batch.
- Price list: each item with its six sales prices and the purchase price.
- References report, Brands report and Item properties report (one line per property, with a page break per family).
- Price list and offer detail: the rules of each price list (price, discount, quantity band, free gift, validity and customer).
- Sales by customer and size, Sales by size, Purchase orders by size and Purchase orders by supplier and size: one line per size and colour of each item.
Sizes come out in rows, one per size and colour, and not in columns as the Desktop ERP printed them.
Warehouse → Warehouse reports also has these, as in the Desktop ERP warehouse menu, each with its four valued versions (at sales, average, last and purchase price) and its stock check:
- Stock below minimum: the items with a minimum set and less stock than that minimum, including those at zero.
- Items without movement: those with stock that have not moved since the day you enter in No movement since (it opens at six months ago). Any stock movement counts: purchases, sales, transfers, production and adjustments, and also the last purchase and last sale brought over by the migration from the Desktop ERP. The Last mov. column says when it last moved; “None” if no movement is known.
- Negative stock.
- Pending orders: those with something still to be received, delivered or transferred.
Purchase forecast tells you what to buy of each item to cover one, two and three months, as in the desktop ERP. It takes what was sold in the last months (you choose how many; ten by default) up to the calculation date and works out the average monthly consumption. It subtracts what you have: stock, plus what is pending to be received and transferred, minus what is pending to be delivered. If the result is negative there is nothing to buy and it shows zero. With Separate warehouses you get one table per warehouse with its total; without it, one row per item with all warehouses added up. Landscape format also shows the item's supplier and its reference. Items with no stock, nothing pending and no sales are left out.
Item labels opens the labels screen, where you choose the items, the format and the copies.
And, in their groups, Price list, Item properties and Item production, which are the same reports as in the purchases, sales and production areas.
The Purchases and Sales groups are the Queries menu of the desktop ERP, with the same reports on both sides:
| Purchases | Sales |
|---|---|
| Incoming detail | Outbound detail |
| Incoming summary by item | Outbound summary by item |
| Incoming summary by supplier | Outbound summary by customer |
| — | Outbound summary by family |
| — | Profit report |
| Purchase orders | Sales orders |
In the desktop ERP, the detail and the orders had a submenu for each order (by supplier or customer, by date, by item, by family). Here each one is a single option and the order is chosen in the Subtotals by filter, which opens on the supplier or the customer, the first option in the desktop ERP.
Stock at date, with the same four valuations and the stock control, gives the stock there was on a past day. It is calculated as in the desktop ERP: today’s stock minus what documents have moved since that day, valued at today’s prices. The control shows the four figures: today’s, what came in and went out afterwards, and what there was. A stock correction made by hand on the item, a stock count or the terminal leaves no movement: if it was made after that date, the report includes it.
In the Production tab, the Components report gives all the bills of materials for a range of items.
The Warehouse tab also has Changed items: the items that were added and the prices that were changed, with the previous price, the new one and who did it. It comes from the change log (see the next section). In the ERP a purchase doesn’t change the item record, so it doesn’t include supplier or warehouse as in the Desktop ERP.
Can I find out who changed something or who has logged in?
Yes, in the System tab of Reports → Reports, if your role has the settings permission:
- User change log: each addition, deletion and change in items, customers, suppliers, sales agents and documents, with the field, the value it had, the one it has now, who did it and at what time. It can be narrowed by dates, user, file and operation type.
- Application access log: each login, including failed ones with their reason, with the workstation and the IP. The Failed only tick box leaves the attempts that didn’t get in.
Both open with today’s date. What comes in through an import doesn’t appear: it isn’t anyone’s change. And they are kept for a year; anything older is deleted automatically.
See also: Run a report · Where each report is · Group and total a report
More about Reports
- How do I group and total a report?
- How do I see what share of the year’s sales falls in a period?
- How do I change the design of an invoice?
- How do I create a custom report?
- Where is each report?
- How do I choose which layout a document is printed with?
- How do I export a report to Excel?
- How do I print labels?
- Running reports and formatting documents
- How do I run a report?