Receipt Bank saves you from having to keep piles of paper by taking all of your invoices and receipts and storing them permanently in the cloud. The data stored in Receipt Bank can then be imported into Clear Books as bills or expenses using our integration.


Find out more about Receipt Bank


Contents


1. Export account codes from Clear Books and import into Receipt Bank

2. Map account codes in Clear Books to account codes from Receipt Bank

3. Import 

3.1 Import bills

3.2 Import Expenses

4. Additional Receipt Bank options for Clear Books Partner


1. Export account codes from Clear Books and import into Receipt Bank


To help maintain the consistency of the account codes you use in Clear Books and those used in Receipt Bank, you can export your list of Clear Books account codes and import them into Receipt Bank.


Navigate to Tools > Export.


Select a period or use the 'From/To' fields to select a custom date range. In the 'Data type' drop-down field select 'Account Codes'. Tick the checkbox to 'Download File' and hit the Go button.


exportaccounts


Log in to Receipt Bank


Navigate to Lists > Categories.


Add a new list via CSV and select the account code list file exported from Clear Books.


add accountlist


2. Map account codes in Clear Books to account codes from Receipt Bank


Once you have exported your account codes from Clear Books and imported them into Receipt Bank, or even if you decide to use the default Receipt Bank account codes, you can now head back to Clear Books and map the two lists against each other. This will mean that every time you import bills or expenses from Receipt Bank, the account codes will be automatically set saving you time.


Log in to Receipt Bank


Navigate to Lists > Categories.


Make sure the correct list is selected in the drop-down field.



Log back into Clear Books and head to Tools > Integrations > Other integrations.


Click on either Import expenses or the Import bills button.


Choose the Receipt Bank account and the Clear Books account.


Importselect RB

Click on the Edit default account mappings button.


Map the categories imported from Receipt Bank (shown in the column on the left) to the account codes within Clear Books using the drop-down fields. Once complete hit the Save button at the bottom.


mapping categories


The Account drop down field will populate automatically based on this mapping. This mapping will be saved for all future imports of either bills or expenses.



3. Import 

3.1 Import bills


Navigate to Tools > Integrations > Other integrations. 


From the selection, choose Import bills for purchase invoices.


Select the appropriate Receipt bank account in the Import data from this remote user drop down field. Select the appropriate Clear Books account in the Target company drop down field.


Importselect RB

Select a date to show items from Receipt Bank after a specific date if appropriate. Also, choose whether to import receipt scans as attached files.


import bills

Assign an account manually to each item. This can be automated by mapping the categories in Receipt Bank to the account codes in Clear Books.



Select which items to import and hit the Import selected items button


3.2 Import Expenses


Navigate to Tools > Integrations > Other integrations. 


From the selection, choose Import Expenses for employee expenses.



Select the appropriate Receipt bank account in the Import data from this remote user drop down field. Select the appropriate Clear Books account in the Target company drop down field.


Importselect RB


Select the employee the imported expenses will be created under in the drop-down field. Tick the checkbox to import expenses with scans to be attached if appropriate.


RB employee select

Assign an account manually to each item. This can be automated by mapping the categories in Receipt Bank to the account codes in Clear Books.



Select which items to import and hit the Import selected items button.



4. Additional Receipt Bank options for Clear Books Partner


If you are a Clear Books Partner and have a Receipt Bank for multiple clients you can set up the Receipt Bank integration on your Partner account and import data into each client account from there.


To begin, log in to your Partner account, head to the Tools > Integrations > Other integrations menu and click on either the Import expenses or the Import bills button.



You will then need to enter your Receipt Bank credentials:



Select the Receipt Bank user from the Import data from this remote user dropdown.



Choose the Target company, this will determine which Clear Books account the expenses and bills will appear in. 

Hit the Next button to proceed.


Finally, select the expenses or bills you would like to import and make sure an account code has been assigned to each transaction.


Hit the Import selected items button to complete.



Technical support is available from Monday to Friday, 9 - 5.


Contact Clear Books Support


We also welcome you to visit our Community to view our latest news & updates, raise new ideas, find answers to common problems, ask new queries and speak to other Clear Books users and employees.