The Fast Data Entry tool in Simple Fund 360 allows users to quickly input and upload large batches of transactions into a bank account. This feature is particularly useful when handling foreign currency transactions, as it automates exchange rate conversions and streamlines reconciliation.

Key Features

• Fast input of multiple cash transactions.
• Supports foreign currency transactions.
• Automatic conversion to AUD using end-of-day exchange rates.
• Seamless integration with the Smart Matching tool for reconciliation.

How to Import Foreign Currency Transactions

From the Main Toolbar, go to Accounting.
Select Smart Matching.

1. Select the Bank Account from the Smart Matching screen.
   
2. Select Data Entry.
   
3. Select the Currency
   
   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.
4. Prepare your spreadsheet with the relevant transaction data ensuring columns match the required format.
   See Fast Data Entry - Spreadsheet Format for more information.
   Copy (CTRL-C) all the bank statement transactions.
5. Paste (CTRL-V) directly into the first cell from the Data Entry - Spreadsheet.
   
   
6. 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

   
   Clear Invalid Entry
   Quickly remove all invalid entries currently entered in the fast data entry screen by clicking on Clear Invalid Entry.
7. Select Create to add the entries to the Smart Matching screen.

Keyboard Shortcuts (Optional – For Faster Input)