How to Import Credit Card Transactions into Sage 50? [Step-By-Step Guide]by Lily Evans Accounting Expert
Once you connect your bank account with the Sage 50 accounting software then it automatically allows you to import credit card transactions into Sage software. Also, after importing all the transactions to your bank account you are not required to enter the bank transactions manually. Moreover, you can also utilize the information imported from the bank to reconcile the payments to outstanding invoices. And thus it automatically creates the bank transactions in Sage accounting software. To get an in-depth knowledge about how to import credit card transactions into Sage 50 go through this entire blog.
Facing issues while trying to import credit card transactions into Sage 50 and want expert’s guidance? Well, don’t worry and reach out to our experts to get complete instructions within the least time possible.
Stepwise Instructions to Import bank transactions
Sage accounting software helps to import the credit card transactions that you have recently downloaded from the internet. But before that you must keep following things in mind to import the bank transactions into Sage 50 easily without any hassle:
While downloading the Internet Bank statement ensure that you have selected the OFX format.
In case you find that your bank doesn’t support the OFX format then you must download the bank transactions in the CSV format.
You must be aware of the fact that when you import or map your bank transactions your system finds no activity within 2 hours. In that case, the system automatically logs off for security reasons.
Continue with the following steps to import credit card transactions into Sage 50 software
In the first place, go to the Banking tab and then click Transactions > Banking menu.
Soon after this, choose the Import Bank Statements options and then click Bank or Credit Card Account from the following list. Consequently, the statement list will be imported into the selected bank or credit card accounts.
Then, you will be displayed with the two Date Range Options i.e All transactions or Date to Import. Click on the option as per your requirement and move ahead.
Now, from the Import Field, select Browse in order to search for your downloaded bank statement (OFX or CSV format).
In case you want to import a CSV file, it will activate the Date Format field.Before importing you must ensure that the CSV file must be in a particular format i.e. with three columns: Date, Description and Amount. The first line displays the column headings whereas the rest have the bank statement information.
Once you have selected your bank statement and bank or credit card account, select the Import File option. BY doing so, it will upload all the details regarding the bank or credit card statement within your Accounting company.
Proceeding further, you will also have the option to view the last ten imported transactions:
If you make changes in the transactions, then it will automatically be saved while moving to the next page.
Then, the accounting will itself detect and display whether the transaction is a receipt or a payment.
Also, the accounting allows you to split transactions on the bank statement and link the amounts to other transactions by clicking on split.
You must ensure that you have selected other transaction that you are splitting the selected transaction with, and enter the required amount.
Later on click Save and then the transactions will appear as split on the Bank Statement and will process the transaction like this when saving.
We hope that the aforementioned steps will help you to import credit card transactions into Sage 50. However, if you still get stuck at any above listed steps, then don’t worry and get in touch with our experts.
Created on Sep 29th 2021 08:19. Viewed 135 times.