Guide 08

Reports, forecasts and repayments

Beyond posting interest, Loanbooq gives you the reports and figures you need to talk to clients and lenders about their loans.

Dashboard

The whole loan book for the organisation, as a table or a chart. Search for a loan, open its full history, and download or email the dashboard as a PDF or an Excel workbook.

Statements and reports

Under Reports, open Send Reports, pick a loan and a period, and download the statement as a PDF. Choose All loans for one report across the organisation.

Emailing a report

Every report, the Forecast and the Dashboard have an Email button beside Download. Enter up to five addresses, choose PDF or Excel, and add a subject and a message if you like. The file is the same one the Download button gives.

  • The email comes from Loanbooq's own address, shown as your name "via Loanbooq", and replies go straight to you.
  • Tick Send me a copy to be copied in.
  • Every email sent is kept in Loanbooq's records, with who sent it and to whom.
To keep Loanbooq's address from being misused, one person can send up to 10 report emails an hour, and an account up to 40 a day.

Under Branding, add your logo, the name shown as Prepared by, your contact details and your colours. They appear on every statement and report.

Forecast

See where a loan is heading month by month, choose how far ahead to look, and add a planned monthly repayment. Download the forecast as a PDF or an Excel workbook, or email it to a client from Loanbooq.

Repayments

Pick a saved loan to pull its history from Xero. You can then:

  • work out the instalment needed to settle the loan by a date;
  • set recurring payments and read the schedule they produce;
  • record a repayment in Xero: enter the date, the amount and the counter account, and Loanbooq posts a journal that reduces the loan's balance.
Bank and control accounts are not offered as the counter account, because Xero does not allow them on manual journals. Choose a clearing or suspense account instead.
Something not working as described? Email hello@loanbooq.com with the organisation, the loan and what you expected to see.