[Zoho Books] How to Manually Import and Upload Bank Statement?
In Zoho Books, apart from leveraging the auto feed connection with your local bank to allow live feed of your bank transaction, you would also be able to manually import and upload your monthly bank statement for your monthly bank reconciliation activity. The manual import of bank statement is an alternative option should the auto feed connection experiencing connection or technical glitch.
Let's take a look the 3 steps involve in importing your bank statement:
- Configure
- Map Fields
- Preview
To begin, go to Banking module and select your respective bank account.
Head over to Setting>Import Statement.
Step 1 - Configure
- Now we are at the first step. As for a first timer conducting the manual import of bank statement it is advisable to download the sample file preferably in CSV or XLS format to view how your bank statement should be presented prior to import it into Zoho Books.
If your bank statement is in PDF format, you are required to convert it into CSV or XLS format.
- Next, you will need to adjust your bank statement to include the following key headers:
- Date
- Description
- Deposits
- Withdrawals
- It is not necessarily to have the exact header name as the bank statement sample, as long as you are aware which to map against Zoho Books fields. More clear explanation regarding this in the Step 2 - Map Fields.
- Upload your adjusted bank statement into Zoho Books.
- Select "Amount Column Type" and proceed by clicking Next.
Your bank statement should consist of either one of the following formats:
- Double Column - Separate amount columns for withdrawals and deposits.
- Single Column and Amount Type - Has amount column and another column indicating if it is a debit or credit.
- Single Column with Negative Values - Single amount column with negative values as withdrawals.
Step 2 - Map Fields
- This step involves mapping up your uploaded bank statement with Zoho Books field which require you to determine your bank statement column to match against Zoho Books field. This step also allows Zoho Books to capture the value/data from your bank statement to be collected to the relevant Zoho Books field.
Kindly ensure you have selected the same date format as your uploaded bank statement.
Step 3 - Preview
- Now your bank statement is ready for import.
Do you have any issues with manually importing or uploading your bank statement? Please share the errors you are experiencing in the comment section below, and we will assist you.
Happy trying!
Related Articles
[Zoho Books] How to Match Payment Received in Foreign Currency?
When a bank feed is matched to a transaction, Zoho Books only displays transactions in the same currency as the bank feed. To rectify the issue of the difference figure between payment made and payment received due to foreign exchange rate captured ...[Zoho Books] Bank Connections for Malaysia
Zoho Books & Yodlee Zoho Books works with a third-party service provider called Yodlee - a major online banking solutions service provider. It is an online banking solution provider that connects to thousands of online banking websites and financial ...[Zoho Books] Enable Payex with Zoho Books
The first of its kind in Malaysia, Payex integration with Zoho Books enables you to accept online payments right from your accounting software! Your customers can now make payments through local Malaysian banks via FPX, credit cards and ...[Zoho Books] How to Raise Debit Note
Steps to Raise Debit Note First thing first you need to enable debit note under Settings -> Preferences -> General: Debit note can only be raised upon an Invoiced being approved and send to customer: You will be able to raise debit note under three ...[Zoho Books] What is Reporting Tag? How to Use it?
The objective of reporting tag is to have sales by item or purchase by item report report based on reporting tag you have created. The reporting tag can be customized according to your requirement. The reporting tag could be created for / based on: ...