Convert many PDF bank transactions files with Dext & import it into Sage Accounting with one file.

Learn how to import a year’s worth of bank transactions from PDF statements into Sage accounting software with a single file import using Dext data extraction online software.

In this video I am going to show you how to solve the problem of getting a large quantity of bank transactions from multiple PDF file formats into Sage Accounting by importing a single file. Once these bank transactions are in the Sage accounting software it can be allocated to the different categories of income, expenses, customers and suppliers.

With this video I am going to prove why the Sage banking accounting software is one of the easiest to work with and most efficient accounting systems on the market.

I am going to use a full year’s of bank statement transactions received in 12 PDF files, one file for each month from a client who needs these transactions to be recorded.

Chapters:
1:21 Content list: The good, the bad & the ugly.
2:15 Step 1: Using Dext to extract the bank data from PDF files.
3:28 Step 2: Download the processed and converted excel bank statements from Dext.
4:03 Step3: Combine all 12 months’ bank transactions in a single file.
5:24 How to check that balances agree on an ongoing basis.
8:44 Check and correct the opening balance of bank transactions before the import.
11:09 More information about the template Sage Import File.
13:07 Step 4: Prepare and reorganise the data according to the Sage Import Template.
14:05 Data import will fail if any cell has more than 100 characters. How to calculate and overcome this obstacle.
16:27 Beware the 2000 limit on the “New Transactions” banking function in Sage Accounting. 16:47 Step 5: Import bank transactions from the CSV file into Sage Accounting.
18:28 Your CSV file import completed successfully.
18:51 How to check how many transactions are in the “New Transactions” banking function of Sage Accounting.
19:11 My thoughts on Sage bank processing and the role of Dext.

We are going to:
1. Start By using Dext Online Software to extract the bank data by uploading the PDF files.
2. Then we are going to download the processed and converted excel bank statements from Dext.
3. Our third step is to combine all 12 months bank data in a single file while ensuring that the bank balances on an ongoing basis.
I am going to show you a set of simple procedures to follow in order to achieve a seamless import that you can employ in your business to get fast, efficient results.
4. The next step will be to prepare the data for the Sage Import. I am going to share important information that will help you to avoid certain pitfalls and ensure a smooth import of your data into Sage Banking.
5. Lastly in step 5 I am going to get all the transactions for the year into Sage with a single import.

To sign up for the sage business cloud accounting 30-day FREE trial:
https://accounting.sageone.co.za/Sign...

Get the Sage CSV Import Template here for free:
https://thefunaccountant.com/importin...

For the full blog post, please visit:
https://thefunaccountant.com/blog/