The 60 JooDax reports: what each shows and how it ties to the books
The same library in the cloud workspace and in the JooDax desktop program: every report is worked out from the documents and entries as they are, keeping no running total of its own.
Sales
- Sales by customerWhich customers bought the most in a period, before and after tax and discount, and how much of it has been paid.
- Sales by productWhich products sell, at what average price and margin, and who sold them.
- Sales by userHow much each member of the team sold in a period, and which documents make it up.
- Sales by sales repHow much each sales rep sold in a period.
- Revenue by sellerHow much each user of the Seller type sold in a period.
- Products sold by supplierHow much of each supplier's goods the business sells, line by line.
- Product sales summaryWhich individual sales made or lost money, product by product.
Receivables
- Customer balancesWhat each customer still owes from the sales of a period, and how much of it has been collected.
- Invoice ageingWhich customers are late and by how long, so collection can start with the oldest debts.
- Bad debtsHow much was lost to customers who will not pay, set against the business they brought in the same period.
- Bank chargesHow much the banks took on the money the business received and paid, and on whose payments.
- Sales invoice statementWhich invoices made money once the cost of the goods sold is taken off.
- Sales invoice summaryWhich customers bring the most profit, not only the most sales.
- Sales summary by userWhat a user sold in a period, how much of it is still to collect, and what came in.
- Customer statementsWhat each customer, with their tax number, bought, paid and still owes in a period.
Payables
- Purchases by supplierWho the business buys from and how much, before and after tax and discount.
- Purchases by productWhat was bought of each product, at what average price, set against what it stands at on the shelf.
- Supplier balancesWhat the business still owes each supplier from the purchases of a period.
- Bill ageingWhich suppliers have been waiting longest to be paid, to plan the payments.
- Purchase bill statementEvery purchase document of a period with its tax, to check against the suppliers' invoices.
- Purchase bill summaryHow much was bought from each supplier, and how much input VAT came with it.
- Purchase order statementWhat the business has ordered from suppliers in a period, billed or not.
- Purchase order summaryHow much has been ordered from each supplier.
- Supplier statementsWhat each supplier, with their tax number, sold to the business, was paid and is still owed.
Payments
- Payment listWhat came in from customers, when, by which method and against which invoice.
- Time to get paidHow long each customer actually takes to pay once invoiced.
- Tax withheld at sourceHow much tax customers withheld from what they paid, customer by customer.
- Credit note detailsWhich credit notes are still waiting to be used, and which invoices the others were set against.
- Credit note statementWhat was credited back to customers in a period, and the VAT that came off with it.
- Credit note summaryWhich customers received the most credit, and how much tax it carried.
- Purchase return detailsWhich purchase returns still have credit left to apply.
- Supplier refund logWhat has been returned to suppliers, against which bills and why.
- Purchase return statementWhat was returned to suppliers in a period, and the input VAT that came off with it.
- Purchase return summaryWhich suppliers the business returns the most to.
- Refund logWhat was given back to customers, why, and against which invoice.
- Purchase payment logWhat was paid to suppliers, when, by which method and against which bill.
Expenses
- Expense listEverything the business spent in a period, one expense at a time.
- Expenses by categoryWhere the money goes, category by category.
- Expenses by customerWhat has been spent for each customer in a period.
- Expenses by supplierHow much is spent with each supplier outside purchase bills.
- Expense category detailsEach expense behind a category's total, with the tax on it.
Taxes
- Sales tax summaryHow much was sold at each VAT rate and the tax on it, before credit notes.
- Purchase tax summaryHow much the business bought at each VAT rate and the input VAT on it.
- Output VATThe document-by-document list behind a period's output VAT, to check before filing.
- Input VATThe document-by-document list behind a period's input VAT, to check before filing.
- Sales VAT by customerA period's output VAT customer by customer, or for one tax number or numbering series.
- Purchase VAT by supplierA period's input VAT supplier by supplier, to check each supplier's tax number and documents.
- VAT returnWhat VAT the books say is due for a period, set beside what the documents say.
Inventory
- Product price listWhat the stock on hand would bring in at today's prices, and the price list itself.
- Products by categoryWhat the stock is worth at cost and at price, by category and warehouse.
- Products by supplierHow much of each supplier's goods is on the shelf, and what it would sell for.
- Product transfersWhat was moved between warehouses, when, by whom and at what cost.
- Stock movementsWhere a product's stock came from and where it went, document by document.
- Supplier stockWhat each supplier's goods on the shelf are worth, and whether the last price paid has moved away from the average.
- Transfer statementWhat a transfer brought into a warehouse, to check against what was counted on arrival.
Accounting
- Profit and lossWhether the business made money in a period, and which revenues and expenses made it so.
- Trial balanceWhether the books balance, and where every account stands.
- Balance sheetWhat the business owns and owes on a given day, and what is left for its owners.
- General ledgerEvery movement on an account, line by line, with its running balance.
- Journal entriesHow a document was posted: which accounts each entry debited and credited.