MoneyWorks can create text files of payments for batch loading into on-line banking software. You would normally do this using the Batch Creditor Payments command see Paying a number of creditors. However you can create manual batches, as described below.
Note: You need to have the appropriate software installed to do electronic transfers—call your bank for details.
To create a payments file for transferring via an on-line banking service:
- Highlight the posted transactions to transfer in the Payments view of the Transactions list window
You can use the Find command to locate the records see Lists.
- Choose Command>Electronic Payments
The Electronic Payments dialog box will be displayed— see Electronic Payments for detail of how this operates.
Most banks now provide a facility for their customers to download bank statements in electronic form.
MoneyWorks allows you to import these bank statements1, and can even automatically code them as they are imported. It provides an easy way to preview the transactions, allowing you to modify the coding, or even apply transactions to outstanding invoices. You can also elect to omit transactions, or have them marked as being ready for reconciliation.
Note: Bank statements should be downloaded from your bank as QIF or Quicken files, a widely used, platform-neutral file format that is supported by most banks. If your bank does not support QIF format, they probably support simple text files such as CSV or tab delimited. These can also be imported into MoneyWorks using the standard Import Transactions command — see Importing into Other Files. However you may have to remove extraneous information (such as account number and opening balances) from the downloaded file.
To import a previously downloaded bank statement
- Choose Command>Load Bank Statement
The Statement Coding window will open.
This allows you to specify the bank account that you are importing, as well as other details pertinent to the import.
Bank: The MoneyWorks bank account into which you want to import the bank statement transactions
Default Income A/c The account code to use for any deposits that cannot be coded using one of the auto-allocation rules. It is good practice to use a special account for this, such as a suspense account or an “Unallocated” account. This makes finding unallocated transactions much easier.
Default Expense A/c The account code to use for any withdrawals that cannot be coded using one of the auto-allocation rules. Again it is good practice to use an “Unallocated” account code (this can be the same as that for deposits)
Exclude items before: Any transactions in the file being imported that are dated before this date will be excluded from the import. This defaults to the date of the last transaction in the prior statement import for this bank.
And after: Any transactions in the file being imported that are dated after this date will be excluded from the import
Auto-Reconcile: If set, each transaction will be compared against existing transactions, and if found to already exist in MoneyWorks will be marked to be omitted. New transactions will be marked as being reconciled.
Swap Payee and Memo: Setting this swaps the Payee and Memo fields around, as some banks get it around the wrong way.
- Choose from the Bank pop-up menu the bank account for which you are loading the statement
The transaction information you have downloaded from the bank refers to one bank account. You need to indicate which one it is.
- If necessary, set the Default Income and Default Expense accounts
These will be remembered from your last bank statement import, but will need to be set the first time you import a bank statement.
- Set the cut-off dates if required
Transactions on the bank statement that are outside of the date range will be ignored. This allows you to download your bank statements and not worry about overlapping dates. When the import is accepted, the before date gets transferred to the after date, ready for the next import.
- If you want to have the transactions automatically marked as being reconciled, set the Auto-Reconcile option
Transactions on the bank statement that can be identified as being already in MoneyWorks will be marked to be omitted, with the existing transaction marked as reconciled; other transactions will be marked as reconciled.
- To import the file, click the Load Statement File button
The standard File Open dialog window will be displayed. Use this to navigate to and open your downloaded bank statement file.
Any transactions inside the nominated date range are imported and listed. Transactions are allocated to the specified default accounts, unless an applicable auto-allocation rule was found, in which case the allocation is made on the basis of the rule. This is shown in the Status column.
- Having made your allocations (see below), click Accept
The transactions will be created with the specified allocations.
1 MoneyWorks supports QIF, OFX, QBO, QFX formats, the most common ones used by banks. ↩