Sometimes it may be necessary to import transactions into Cloud Banking. This article will detail the procedures for doing so.
: Get the transactions from your bank or credit card's online banking site.
Each financial institution has a different way of downloading transactions. If you cannot find the procedure for doing this step, contact your financial institution for instructions. Most banks allow you to specify a date range and a file format. Make sure when choosing the date range that you are not overlapping dates for transactions that are already in AccountingSuite™ as you will run the risk of importing duplicates. When selecting a file format, AccountingSuite™ can handle IIF, QIF, OFX, QFX, TXT, CSV, or XLS types.
: Navigate to
Bank / Cloud Banking.
: Choose the
from the drop down list.
: Click the
: Choose the file for import.
Click ok on the pop-up window.
used in the file (most always a comma in a csv, a tab in a tsb)*
: If the file has a header row, check the checkbox.*
Map the columns. In the grid at the bottom, choose the AccountingSuite™ field for each column in the spreadsheet. Keep in mind the first row may contain headers. After mapping, look at the data in the rows 1, 2, and 3 in the grid for samples. The Money in column should have positive numbers and the Money Out column should have negative numbers. If they do not, use the Change Sign checkboxes as needed in the mapping section above the grid.*
A summary page appears with the first few rows of data. Look at the toggle above the grid with For Upload, Incorrect, All toggles. Each one will indicate a number representing how many transactions fall into the category. If there are any in incorrect, you may have to add those manually or fix the data in the spreadsheet. Clicking incorrect will show the transactions and the problems that they have so that they may be fixed.*
: Click continue.*
The next screen will compare the date range of transactions in the sheet with the period selected in Cloud Banking. If some transactions fall outside of the period you may choose to import all or import only those that are within the range.
Click continue. The transactions will be imported.
NOTE: If the system suspects any duplicate transactions, you will be prompted with a choice to import or ignore the suspected duplicate.
*If choosing a file format that is NOT a txt, xls, or csv, the system will skip this step.