A module for Front Accounting that provides automated import of transactions from csv files exported from your bank.
- Match lines in a bank account file to a customer, supplier or a quick entry.
- Automatically generate a simple direct supplier invoice.
- Automatically allocate deposits to customer invoices, if there is a reference in the line that can be used to match to the invoice number.
The module needs to be unpacked and exist in the folder
./modules/sgw_import.
As with all modules you will need to set permissions for any user, including the system admin, in the setup menu. You will need to logout and login again after doing this.
TLDR ...
The menu items Import Transactions and Configure Import Transactions have been added under the Banking and General Ledger menu.
Import Transactions, upload a csv file setting the correct bank account.Configure Import Transactions, set the date field, date format, and amount field. Optionally hide some columns you don't need to see in the import transactions screens.- Back to
Import Transactions. Click the filename or number. Add line definitions to those pesky recurring transactions. It's ok to leave some that are one off, or better done manually.