The web back office · 27 articles

Run and read back office reports

The back office has reports on sales, profit and loss, tax, stock, payments, staff, tables and accounts. Each one has filters by date and location and can be exported.

Reports27

Run and read the Daily Sales ReportThe Daily Sales Report is the on-screen version of the end-of-day PDF. Go to Reports > Daily Sales Report (/reports/daily-sales-report), choose a Business Location and a Date Range, and click Show. The report lists net sales, GST, PST and the total including tax, then tips, payment methods, sales by category and discounts for the period. Download PDF saves a copy and Email Report sends the PDF to any addresses you type.Run and read the Profit / Loss ReportThe Profit / Loss Report works out gross and net profit for a period. Go to Reports > Profit / Loss Report (/reports/profit-loss), pick a location in the location box and use Filter by date to set the period. The top half lists opening and closing stock, purchases, expenses, adjustments, shipping, discounts and returns; Gross Profit and Net Profit appear below with the formula used. Tabs underneath split profit by products, categories, brands, locations, invoice, date, customer and day.Run and read the Purchase & Sale ReportThe Purchase & Sale Report puts what you bought next to what you sold for a period. Go to Reports > Purchase & Sale (/reports/purchase-sell), pick a location and use Filter by date. The Purchases box shows total purchase, purchase including tax, purchase returns and purchase due; the Sales box shows the same for sales. The Overall line takes sale minus sale return minus purchase minus purchase return, and Due amount shows what is still owed either way.Run and read the Tax ReportThe Tax Report compares the tax you charged with the tax you paid. Go to Reports > Tax Report (/reports/tax-report), choose a Business Location and Date Range. Three figures appear at the top: Input Tax (on purchases), Output Tax (on sales) and Expense Tax (on expenses), with the overall result of Output Tax minus Input Tax minus Expense Tax. Tabs below list each purchase, sale and expense with its tax by rate.Run and read the Supplier & Customer ReportThe Supplier & Customer Report shows each contact's account in one row. Go to Reports > Supplier & Customer Report (/reports/customer-supplier) and filter by Customer Group Name and Type. Each row lists the contact's total purchase, purchase return, sale, sell return, opening balance due and the due amount, where a positive value is money to receive and a negative value is money to pay.Run and read the Customer Groups ReportThe Customer Groups Report totals your sales for each customer group. Go to Reports > Customer Groups Report (/reports/customer-group), choose a Customer Group Name if you want just one, a Business Location and a Date Range. The table lists each Customer Group with its Total Sale for the period.Run and read the Stock ReportThe Stock Report shows what you have on hand and what it is worth. Go to Reports > Stock Report (/reports/stock-report) and filter by Business Location, Category, Sub category, Brand and Unit. The boxes at the top give closing stock value by purchase price and by sale price, potential profit and profit margin %. The table lists every product with its unit price, current stock, stock value, units sold, transferred and adjusted.Run and read the Stock Expiry ReportThe Stock Expiry Report lists stock with expiry dates so you can sell or clear it in time. Go to Reports > Stock Expiry Report (/reports/stock-expiry), filter by Business Location, Category, Sub category, Brand or Unit, and use View Stocks to pick a window such as Expired, Expiring in a week or Expiring in a month. Each row shows the product, SKU, location, stock left, lot number, EXP Date and MFG Date. Write off expired units with a stock adjustment.Run and read the Lot ReportThe Lot Report follows stock lot by lot. Go to Reports > Lot Report (/reports/lot-report) and filter by Business Location, Category, Sub category, Brand and Unit. Each row shows the product, SKU, Lot Number, EXP Date, Current stock, Total unit sold and Total Unit Adjusted, which helps with recalls and stock counts.Run and read the Stock Adjustment ReportThe Stock Adjustment Report totals the stock you wrote off. Go to Reports > Stock Adjustment Report (/reports/stock-adjustment-report), choose a location and use Filter by date. Four totals appear: Total Normal, Total Abnormal, Total Stock Adjustment and Total Amount Recovered. The Stock Adjustments table below lists each one with date, reference, location, type, amount, amount recovered, reason and who added it.Run and read the Trending Products reportTrending Products charts your best sellers. Go to Reports > Trending Products (/reports/trending-products), set Business Location, Category, Sub category, Brand, Unit, Date Range, Number of products and Product Type, then click Apply Filters. The Top Trending Products chart shows the products that sold the most units in that selection.Run and read the Items ReportThe Items Report follows each item from the purchase it came in on to the sale it went out on. Go to Reports > Items Report (/reports/items-report) and filter by Supplier, Purchase Date, Customer, Sell Date and Business Location. Each row shows the product, SKU, supplier, purchase date and price, customer, sell date, selling price, quantity and subtotal.Run and read the Product Purchase ReportThe Product Purchase Report lists every purchase line by product. Go to Reports > Product Purchase Report (/reports/product-purchase-report), search a product or scan its barcode, and filter by Supplier, Business Location and Date Range. Each row shows the product, SKU, supplier, reference number, date, quantity, units adjusted, unit purchase price and subtotal.Run and read the Product Sell ReportThe Product Sell Report lists what you sold, item by item. Go to Reports > Product Sell Report (/reports/product-sell-report), search a product or leave it empty, and filter by Customer, Business Location, Category, Food Type, Date Range and Time range. The Detailed tab lists each sale line; Detailed (With purchase) adds the purchase reference, lot and supplier; Grouped totals units sold per product with current stock.Run and read the Purchase Payment ReportThe Purchase Payment Report lists the payments you made to suppliers. Go to Reports > Purchase Payment Report (/reports/purchase-payment-report) and filter by Supplier, Business Location and Date Range. Each row shows the reference number, paid on date, amount, payment method and the purchase it paid, with a total at the bottom.Run and read the Sell Payment ReportThe Sell Payment Report lists the payments customers made. Go to Reports > Sell Payment Report (/reports/sell-payment-report) and filter by Customer, Business Location, Payment Method, Customer Group and Date Range. Each row shows the reference number, paid on date, amount, payment method and the sale it paid, with totals at the bottom.Run and read the Expense ReportThe Expense Report shows where your money went by expense category. Go to Reports > Expense Report (/reports/expense-report), choose a Business Location, a Category if you want one, and a Date Range, then click Apply Filters. A chart shows spending by category and the table lists each Expense Category with its Total Expense.Run and read the Register ReportThe Register Report lists every cash register session. Go to Reports > Register Report (/reports/register-report) and filter by User, Status (Open or Close) and Date Range. Each row shows the open time, close time, location, user, total card slips, total cheques and total cash, and Action opens the register details with totals by payment method.Run and read the Sales Representative ReportThe Sales Representative Report shows each person's sales, returns, commission and expenses. Go to Reports > Sales Representative Report (/reports/sales-representative-report), choose a User, a Business Location and a Date Range. The Summary shows Total Sale, Total Sales Return, Total Sale Commission and Total Expense; tabs list the Sales Added, Sales With Commission and Expenses behind them.Run and read the Table ReportThe Table Report totals sales for each restaurant table. Go to Reports > Table Report (/reports/table-report), choose a Business Location and Date Range, and read Total Sale for every Table. It appears when the Tables module is on.Run and read the Service Staff ReportThe Service Staff Report shows what each server handled. Go to Reports > Service Staff Report (/reports/service-staff-report), choose a Business Location, a Service staff member or All, and a Date Range. The Orders tab lists each order with subtotal, discount, tax and total; the Line Orders tab lists each item they served.Read the Activity LogThe Activity Log is an audit trail of changes in the back office. Go to Reports > Activity Log (/reports/activity-log) and filter By (the user), Subject Type and Date Range. Each row shows the date, the action taken and a note. Only admins can open it.Run and read the Balance SheetThe Balance Sheet compares what you owe with what you own on a date. Go to Payment Accounts > Balance Sheet (/account/balance-sheet) and set Filter by date to the day you want (today by default). The Liability column shows supplier due; the Assets column shows customer due, closing stock and each payment account's balance, with Total Liability and Total Assets at the bottom. Click Print for a copy.Run and read the Trial BalanceThe Trial Balance lists debit and credit totals so you can check they balance. Go to Payment Accounts > Trial Balance (/account/trial-balance) and set Filter by date. Rows show Supplier Due, Customer Due and each payment account's balance in the Credit or Debit column, with a Total row for each column. Click Print for a copy.Run and read the Cash Flow reportThe Cash Flow report follows money in and out of your payment accounts. Go to Payment Accounts > Cash Flow (/account/cash-flow) and filter by Account, Date Range and Transaction Type (Debit or Credit). Each row shows the date, account, description, credit, debit and a running balance.Run and read the Payment Account ReportThe Payment Account Report shows which account each payment went to and fixes payments with none. Go to Payment Accounts > Payment Account Report (/account/payment-account-report) and filter by Account (or None for unlinked payments) and Date Range. Each row shows the date, payment reference, invoice or reference number, payment type and account, and Link Account attaches the payment to an account.Read Product Stock DetailsProduct Stock Details checks a product's stock against every movement and fixes a mismatch. It has no sidebar entry: open /reports/product-stock-details in the back office, search the product, choose a Business Location and click Search. The table lists opening stock, purchases, purchase returns, adjustments, transfers in and out, sales, sell returns and production, then Correct Stock (total stock calculated) beside Incorrect Stock (total stock available), with a Fix button.