The reports you can run in Slate

Periodic VAT report, Detailed VAT report, Income report, Profit and loss, Receivables aging, Sales by item, Payments by method and Ask your books. Every screenshot here was taken in the demo account, with made-up business data. Each report is derived from the documents you issued and the expenses you recorded, so two reports covering the same period show the same numbers.

Periodic VAT report in Slate

Periodic VAT report

Output VAT from the documents you issued against input VAT from the expenses you recorded, for a single month, a bimonthly period or a date range. The result is the amount payable, or refundable when input VAT is larger, with breakdowns by document type and by month under the summary. An osek patur never sees this report.

Detailed VAT report in Slate

Detailed VAT report

Downloads as CSV

One line per invoice on both sides, and from it a PCN874.TXT file for a whole calendar month. An identified customer gets its own record under code S, an unidentified one joins an aggregate under code L, an identified supplier gets code T and the rest go to petty cash under code K. The download stays blocked until the amounts match the periodic VAT report, and the checks that would fail a transmission are listed first: a separate record with no customer tax id, an invoice missing an allocation number, petty cash over the ceiling.

Income report in Slate

Income report

Downloads as CSV

Revenue by month and by customer, with each customer’s share of turnover. Only issued documents count: tax invoices, invoice-receipts and transaction invoices. Credit invoices are subtracted, and receipts are skipped so the invoice that already booked the income is not counted twice. For an osek patur, income is counted from receipts instead.

Profit and loss in Slate

Profit and loss

Downloads as CSV

Revenue before VAT minus recognized expenses, by month, with profit and margin alongside expenses by category. An expense enters at the recognized amount set when it was recorded rather than at the invoice figure. A fixed asset counts in full in the month it was recorded, because depreciation is not calculated in the system yet.

Receivables aging in Slate

Receivables aging

Downloads as CSV

What is still uncollected, per customer, in buckets of up to 30 days, 31 to 60, 61 to 90 and over 90, with the oldest open documents under the table. An Israeli receipt is not tied to a specific invoice, so a customer’s payments are applied against their open invoices oldest first, each currency separately. A payment request counts as open debt, and an invoice-receipt counts as paid on issue.

Sales by item in Slate

Sales by item

Downloads as CSV

Document lines grouped by item name, with quantity, unit, average price, amount and share of sales. Amounts are before VAT and after line discount, and a credit invoice reduces both the quantity and the amount. Grouping follows the name as saved on the document rather than a product card, so the same service written two ways is counted twice.

Payments by method in Slate

Payments by method

Downloads as CSV

How much actually came in as cash, checks, card and transfers, with each method’s share and a monthly breakdown. The data comes from the payment lines on receipts and invoice-receipts, and one receipt can combine several methods. Each method counts on its own payment date, so a postdated check lands in the month it clears.

Ask your books in Slate

Ask your books

Free-text questions over the same data, such as what share of revenue comes from the five largest customers, or how many quotes turned into invoices this month. Meant for the questions no fixed report answers exactly.

Where the numbers come from

There is no screen for typing amounts into a report, and no side spreadsheet to reconcile at the end of the period. Every report reads the documents you issued and the expenses you recorded, which is why the detailed VAT report and the periodic VAT report have to agree, and why the filing file cannot be downloaded while they do not.

What comes out as a file

Six of the reports download as CSV, and the detailed VAT report also produces the PCN874.TXT file itself. Beyond the reports you can generate an Open Format file for a tax year or a date range, and export documents, customers and items to CSV in the same columns the import screen reads, so the file goes back in without editing.

Not every business sees the same reports

An osek patur charges no VAT, so neither VAT report is shown to them at all. An individual gets one more report that is not pictured here, a simulation of how much income tax and national insurance a pension and hishtalmut deposit would have saved, and it is hidden from a company or a partnership because it is built on personal tax brackets.

Seeing it on live data

The demo account opens with no registration and no password, on the same data as the screenshots here. You can change periods and open every report, but not edit anything or issue documents.

Want these reports on your own data

Registration is open, at no cost and with no document cap.

Open a free account