Entering bank statements manually

You can enter a bank statement manually into MYOB Essentials Cashbook using the Manually enter transactions page. You only need to enter statements manually if you have bank or credit card accounts that you haven’t set up a bank feed for, or if you are missing transactions for a particular period. 

While you are entering the transactions here, you can choose which account they should be allocated to and also also split the allocation across two or more accounts. You can also create a rule.

Transactions that are entered this way will appear in the View and match transactions page.

To enter a bank statement manually

1. Open the cashbook for the relevant business.
2. Go to Banking> Enter bank statement. The Manually enter transactions page appears.
3. Select the bank or credit card account for which you are entering the statement.
4. Enter a reference. For example, this could be the bank statement number or a short description.
5. Enter the opening balance and press ENTER or TAB. You will now be able to enter the transactions row by row.
6. If you'd like to have the date or description (from the last row you entered) repeated on each line, select the checkboxes in Repeat last row. You can always change these automatically-entered fields at any time.
   
7. Start entering the transactions row by row. You can also choose which account to allocate each transaction to.
8. If you need to allocate a transaction across two or more accounts:
   1. Click the arrow ( ) to expand the transaction.
   2. Open the Split transaction panel.
   3. Fill the fields in the Allocate and Remaining rows to split the transaction across multiple accounts, using either percentages or amounts.
   For more details, see the steps in To split a transaction across multiple accounts.
9. To create a rule from the transaction you are entering:
   1. Click the arrow ( ) to expand the transaction.
   2. Open the Create rule panel.
   3. Fill out the criteria for the rules, and specify how to allocate the transaction.
   For more details, see Allocation rules.
10. If you want to add a note to the transaction, click the arrow and open the Note panel.
11. When you're finished, click Done adding transactions.

The statement summary will now be listed at the end of this page, and your transactions will appear in the main View and match transactions screen.

Keyboard shortcuts x

Use the following keyboard shortcuts to speed up the process of entering a bank statement.

~ + SPACEBAR

To delete or undo an entered bank statement

1. Open the cashbook for the relevant business.
2. Go to Banking> Enter bank statement. The Manually enter transactions page appears.
   The statements you have entered appear at the end of the page.
3. Locate the statement you want to delete and click the arrow next to it ( ).
4. Click Undo. A warning message appears, informing you that all the transactions entered as part of this statement will be deleted.
5. To confirm the deletion, click Yes, Undo.