BLACK FRIDAY35% OFFfor life on any plan at checkout with code SeroBF35 · only 100 coupons, first come first served · ends 30 Octoberfor life · code SeroBF35 · first 100
SeroBooks
Knowledgebase · 23 articles

Reports

The Report Centre, running and customising reports, drilling down, memorising, commenting, and every report explained.

Using reports9

The Report CentreBrowse, search and pin every report SeroBooks can produce, open one with a click, and build reports of your own.Running a report: dates, filters and refreshOpen any report, set its dates, narrow it to one customer, vendor or location, search and filter its lines, fold it by month and compare it with last year.Customise a report: columns, filters, header and footerChoose which columns a report shows, size them, set how negative numbers and cents appear, and decide what a printed report carries in its header and footer.Drilling down from a reportClick any figure or line on a report to see what is behind it: a more detailed report, the invoice or bill itself, a customer's ledger, an item's history or a journal entry.Print, export and email a reportPrint a report to your report printer, save it as Excel, CSV or PDF, or email it as an attachment, with exactly the figures, filters and columns on screen.Memorized ReportsSave a report with its filters and a relative period such as "last month", find it again under Saved Reports, preview it, change it or delete it.Scheduled ReportsHave SeroBooks email a memorized report every day, week or month, as a spreadsheet, to anyone you choose, and check that each delivery went out.Comment on Report and Commented ReportsKeep a copy of a report with your notes beside individual figures, print it with the notes, and find it again under Commented Reports.The Sales, Purchases, Inventory, Damaged and Tax report screensFive quick report screens that sit beside the Report Centre: daily sales, bills, live stock value, damaged-goods write-offs and tax collected by rate.

Every report, explained14

Company & Financial reportsEvery Company & Financial report explained: the Profit & Loss family, income by customer and expenses by vendor, the Balance Sheet family, cash flow, the MIS pack (funds flow, ratios, party abstracts, profitability) and exchange gains and losses.Sales Tax reportsEvery sales tax report explained: the GST/HST Return and its detail, the PST / QST Return, the review reports to run before filing, and Sales Tax Liability.Customers & Receivables reportsEvery report about what customers owe and how they pay: A/R aging, open invoices, collections, money to collect by due date, customer balances, days to pay, customer ranking and inactive customers.Sales reportsEvery Sales report explained: sales by customer, item, rep, place, channel, location, category and brand; trends by month, day and hour; this year against last; profitability, discounts and returns; open sales orders, estimates and pending sales.Jobs, Time & Mileage reportsEvery Jobs, Time & Mileage report explained: job profitability, estimates against actuals, unbilled time and costs, hours by job and by person, and mileage by vehicle and by job.Vendors & Payables reportsEvery report about what you owe your vendors: A/P aging, unpaid bills, bills by due date, vendor balances, bills with their payments, and every transaction by vendor.Purchases reportsWhat you bought, from whom, at what price and when: purchases by vendor, item, category, month and location, open purchase orders, goods received, returns to vendors, and expenses by category.Inventory reportsWhat stock you hold, where it is, what it is worth, how it moved, what is running low, what is not selling, and what was written off.Employees & Payroll reportsThe payroll register, payroll totals per employee for reconciling T4s, the history of source deduction remittances, and the list of payroll items.Banking reportsMoney in and money out by payment method, payments received day by day, cheques written and received, gaps in the cheques you wrote, and every bank and card reconciliation.Accountant & Taxes reportsThe reports an accountant works from: trial balance, adjusted trial balance, general ledger, journal, transaction detail and lists, the audit trail, voided and deleted transactions, closing date exceptions, and the checks that prove the books are complete.Budgets & Forecasts reportsYour budgets on paper and against what actually happened: the Profit & Loss and Balance Sheet budget overviews, Budget vs. Actual for the company, by class and by job, and Profit & Loss Budget Performance.List reportsPrintable lists of your customers, vendors, items, prices and staff: contact lists, phone lists, the item price list, the item listing and the employee contact list.Amazon reportsAmazon sales by marketplace and by fulfilment, refunds by item, Amazon's fees by type, and each settlement payout broken down, ready to print, export or schedule beside your other reports.