Skip to main content

ChapterFinance & Cash Register

Chapter 12 — Finance reports and exchange rates

Twelve reports, printed as PDF or exported to Excel, tell you what the cash register holds, what third parties owe and what the loans still cost. And the Central Bank of Tunisia's rates can be read day by day.

In this chapter

  • The reports page and its parameters window
  • The cash register, withholding and loan reports
  • The customer and supplier reports
  • The CBT rates
  1. Choose a report
  2. Parameters
  3. PDF
  4. Excel
Book contents

The Finance reports page

The Finance reports page: twelve tiles, each as PDF or Excel
  1. 1. The cash register reports: safe inventory, bank deposits, collections.
  2. 2. Withholding and loans: supplier withholding tax, outstanding loans, outstanding amounts by year.
  3. 3. The statements: customer, supplier, and the outstanding bills schedule.
  4. 4. The outstanding items: open items, customer risk, receivables by age.
  5. 5. PDF, Excel: the formats offered; you choose in the report's window.

Each tile opens a parameters window (dates, cash register, type, third party…), then Print PDF or Export Excel. The "Print the selection criteria" box adds the chosen filters at the top of the PDF. A tile for which you do not have the rights is greyed out.

The cash register reports

ReportWhat it showsParameters
Safe inventoryThe cheques and bills of exchange that were in the safe on a date, item by item, and the balance of the cash and of the other methods tracked in the register on that date. Register by register, type by type, with subtotals.Date, cash register, type
Bank deposits reportThe deposits made to the bank over a period: document number, submission (for discount or for collection), bank, number of items, status (In progress, Deposited, Unpaid, Partly unpaid).Period, cash register, type (cash, cheques, bills)
Collections reportThe customers' collections over a period, with the documents settled and the state of each payment (In the safe, Deposited, Collected, Exchanged, Rejected for a cheque or a bill; In progress or Collected for a transfer; Received otherwise).Period, cash register, type (one payment method)

The safe inventory is a reconstruction: it says what the safe contained on that day, even if the cheques have been deposited since. The financial situation, on the other hand, reads today's state.

The three cash register reports only offer the cash registers that you can see (chapter 2).

Withholding and loans

ReportWhat it shows
Supplier withholding taxThe withholdings of the certificates issued over a period (payment date), supplier by supplier (code, name, tax ID): gross, withholding, net; then a summary by nature and by rate, the one the tax return asks for. Draft, cancelled or rectified certificates are not included.
Outstanding loans reportOne loan per line: instalments due, remaining principal and interest, outstanding amount including tax, next instalment (marked "due" or "unpaid"). Filter: the lending institution.
Outstanding principal and interest by yearThe instalments still to be paid, year by year (year of the due date), with or without the detail of each instalment.

These two loan reports follow the rule of the cards on the financing page (chapter 11): active or closed credits, instalments neither paid nor cancelled.

The customer and supplier reports

ReportWhat it shows
Customer statementA customer's movements over a period: their documents on the debit side, their payments on the credit side (for the part allocated to those documents), their unpaid items, and the running balance from a "Solde antérieur" (previous balance).
Supplier statementThe same for a supplier: their invoices and goods receipts, the payment orders issued, the unpaid items.
Outstanding bills scheduleThe bills of exchange (or the cheques, or both) given to suppliers and not yet declared paid, by bank then by month of maturity.
Open itemsThe open documents and their balance due, filtered by type, third party, representative, city, region, method and payment status. It also exists for suppliers.
Customer riskPer customer, on the day: unpaid invoices and pre-invoices, cheques and bills in the safe, VNR (deposited, not yet collected), ENE (bills handed in for discount, not yet due), unpaid items, minus advances. A customer whose total is nil is not printed.
Customer receivables ageingThe amount due per customer, by age band (less than 30, 60, 90 days, more than 90 days), pre-invoices and invoices, at a reference date.

The CBT exchange rates

This screen is open to every member of the firm, with or without the Finance module, read-only. It shows the average rates of the currencies quoted in dinars that the Central Bank of Tunisia (CBT) publishes every working day, late in the afternoon. IntegraSys records them day by day: you find the rate of a past date without going to the CBT website.

The CBT rates requested for 18/10/2026: the latest publication, that of 14/10/2026
  1. 1. Date and Show: the date you want; Show reads it again.
  2. 2. Rates of …: the publication actually displayed.
  3. 3. The notice: no publication that day, here is the latest one before it.
  4. 4. Unit and Value: the value in dinars of the unit shown (1, 10, 100 or 1000).
  1. The Exchange rates table page opens on today's date.
  2. For another date, enter it in Date, then click Show. A future date greys out the button.
  3. Read the table: Currency, Code, Unit, Value. For the yen, the unit is 1000: 18.8874 dinars for 1000 yen, not for one.
  4. Print opens the table as a PDF ("Tableau des cours devises", the day, and the source: Banque Centrale de Tunisie).
  • A day without a publication (weekend, public holiday, today's rates not yet published) shows the latest previous publication, at most ten days earlier, and says so.
  • Screen left open since the morning? Click Show again: it fetches today's rates (the CBT is queried at most every fifteen minutes for the same date).
  • A date not yet recorded is read from the CBT website on demand: the display can take up to about twenty seconds.

These rates are used elsewhere: the suggested rate of a Foreign payment (chapter 8) first takes the rates that the firm entered itself, then the CBT's; the accounting module's foreign purchases integration wizard, for its part, suggests the rate of the day of the transaction or the first publication after it.