How to import bill payments

You can use the import bill payments tool to pay off multiple bills with multiple separate payments. Only files in .CSV format are supported. The bill number, the payment date and the payment amount are all required fields. 

You can export the purchase ledger from the Tools > Export menu which may aid you in listing all the unpaid bills IDs.

Step 1.

Navigate to the Tools > Import > Overview menu and click on the CSV Import link.

Step 2.

Click on the Bill payments link.

Step 3.

Select a bank account in the drop down box, then drag and drop your file on the designated area or click on the Upload a CSV text to select your file from your computer.

Note that a template is provided below this which you copy your data into, to make sure the data uploaded is in the correct format.

Step 4.

Now map the columns of the spreadsheet to the fields on Clear Books. The bill number, the payment date and the payment amount are all required fields. 

Click on Import button to complete.