Overview
Quickly create and import multiple cash items for a bank account using the Data Entry screen. These transactions can then be easily reconciled via Smart Matching.
Foreign Currency Conversion
Fast Data Entry supports multiple currencies. To input bank data in a foreign currency, select a currency from the drop-down list and input amounts in the foreign currency.
Simple Fund 360 will populate the end of day rate in the XRT Column and convert amounts to AUD when uploaded.
Screen Shortcuts
PC
|
|
---|---|
Shortcut
|
Explanation
|
Enter Key | Move down a row |
Shift + Enter |
Move up a row |
Tab Key | Move forward to the next cell |
Shift + Tab | Move backward to the previous cell |
Ctrl + C | Copy field |
Ctrl + V | Paste a copied field |
Swap Dr/CR | Swap Dr/Cr columns |
Mac | |
---|---|
Shortcut
|
Explanation
|
Return | Move down a row |
Up Arrow |
Move up a row |
Tab Key | Move forward to the next cell |
Shift + Tab | Move backward to the previous cell |
Command + C | Copy field |
Command + V | Paste a copied field |
Swap Dr/CR | Swap Dr/Cr columns |
Coding
1. Open Spreadsheet and copy (CTRL-C) all the bank statement transactions.
Note: Ensure the spreadsheet columns are formated appropriately, See Fast Data Entry - Spreadsheet Format for more information.
2. Navigate to Smart Matching.
From the Main Toolbar, go to Accounting. | ![]() |
Select Smart Matching. | ![]() |
3. Select the Bank Account from the Smart Matching screen.
4. Select Data Entry.
5. Paste (CTRL-V) directly into the first cell from the Data Entry - Spreadsheet.
As entries are recorded to the Data Input page, the entry summary field will update below:
Field
|
Explanation
|
---|---|
Valid Entry | Number of entries that have been recorded correctly |
Invalid Entry | Number of entries that have been recorded incorrectly (missing fields) |
Opening Balance | Bank balance prior to coding transactions |
Total Spent | Sum amount of DR entries |
Total Received | Sum amount of CR entries |
Closing Balance | Sum of CR-DR entries + Opening Balance |
Quickly remove all invalid entries currently entered in the fast data entry screen by clicking on Clear Invalid Entry.
6. Select Create to add the entries to the Smart Matching screen.