Re-typing figures invites errors. Exporting your statement as a CSV lets your accounting software read the transactions directly, so reconciliation is a match-and-confirm rather than manual entry.
How to export CSV
- Go to Statements or Account > Activity and choose Export > CSV.
- Set the date range you’re importing.
- Save the file and import it into your software’s bank/loan feed or manual import.
Mapping the columns
The CSV includes the date, a description, the amount and the running balance — the fields most packages expect. Map drawings to the loan account as increases, repayments as decreases, and interest to your finance-cost account. Because the figures are fixed and simple, once the mapping’s set the first time, every future import is a two-minute job.
If your software prefers a specific date or amount format, most let you set that on import; do it once and save the template. And keep a copy of the raw CSV with your records — it’s the source your imported figures came from, so it’s worth having if a number is ever queried later.
Your facility is priced with simple interest and the figures fixed up front on your Key Information Sheet, so nothing here changes what you owe by surprise — it only changes how you view, manage or evidence it.
See also: How to reconcile a statement in your accounting software, How to export your account history, How to download several months at once.