Efficiently Allocate Bank Transactions In Myob: A Step-By-Step Guide

Allocating bank transactions in MYOB is a crucial task for maintaining accurate financial records and ensuring that your business’s accounts are up-to-date. This process involves matching bank transactions imported from your financial institution with corresponding entries in MYOB, such as invoices, bills, or expense claims. Proper allocation helps reconcile accounts, track cash flow, and identify discrepancies. In MYOB, you can use the Bank Register or the Spend/Receive Money features to allocate transactions, ensuring that each entry is correctly categorized and linked to the appropriate account or contact. Understanding this process not only streamlines your bookkeeping but also provides a clear financial overview, enabling better decision-making for your business.

Explore related products

Quick and Easy Guide to Bank Reconciliations: Get to grips with your cash flow and know what goes where and why (Anna's Simple Accounting Guides Book 2)

$3.93 $7.54

Distressed MYOB MIND YOUR OWN BUSINESS T-shirt T-Shirt

$16.99

MYOB Mind Your Own Business! T-Shirt

$15.99

MYOB For Dummies

$19 $31.69

Setting up bank accounts in MYOB

After creating the bank account, you’ll need to set up the opening balance to ensure accurate reconciliation. Go to the newly created bank account and click on Spend Money or Receive Money, depending on whether the opening balance is a debit or credit. Enter the opening balance amount and ensure the date reflects the start of your accounting period. This step is critical as it establishes the baseline for all future transactions. If you’re unsure of the opening balance, refer to your latest bank statement for accuracy.

Next, enable bank feeds to automatically import transactions from your bank into MYOB. From the Bank Accounts menu, select the account you wish to connect and click on Set up bank feed. Follow the prompts to link your bank account securely. Bank feeds streamline the transaction allocation process by reducing manual data entry and ensuring real-time updates. Note that not all banks support this feature, so check MYOB’s compatibility list if you encounter issues.

Once your bank account is set up and connected, familiarize yourself with the Bank Register in MYOB. This is where all transactions will appear, either manually entered or imported via bank feeds. The register allows you to view, edit, and allocate transactions to specific accounts or categories. Before allocating transactions, ensure all chart of accounts and categories are correctly set up in MYOB to maintain accurate financial records.

Finally, perform a test reconciliation to ensure your bank account is set up correctly. Go to the Banking menu, select Reconcile Accounts, and follow the prompts to match MYOB transactions with your bank statement. If discrepancies arise, review the opening balance, imported transactions, and allocations. Regularly reconciling your accounts will help you identify and resolve issues early, ensuring smooth transaction allocation in the future.

Importing bank statements for reconciliation

Importing bank statements into MYOB for reconciliation is a streamlined process that saves time and reduces manual data entry errors. To begin, ensure your bank supports electronic statement downloads in a format compatible with MYOB, such as CSV, QIF, or OFX. Log in to your online banking portal and download the statement for the desired period. Save the file to a location on your computer where you can easily access it during the import process. Before importing, review the statement to ensure all transactions are accurate and complete, as this will make the reconciliation process smoother.

Once the bank statement file is ready, open your MYOB software and navigate to the Banking module. Select the Spend Money, Receive Money, or Bank Register depending on the type of transactions you’re importing. Look for the Import Bank Statements option, typically found under the File menu or within the banking transaction window. MYOB will prompt you to select the file you downloaded from your bank. Choose the correct file and follow the on-screen instructions to map the statement fields (e.g., date, description, amount) to the corresponding MYOB fields. This step ensures the data is imported accurately.

After mapping the fields, MYOB will display a preview of the transactions to be imported. Review this carefully to ensure all transactions are correctly formatted and there are no discrepancies. If any issues arise, such as unmatched fields or unrecognized transactions, you may need to adjust the mapping or edit the statement file before proceeding. Once satisfied, confirm the import, and MYOB will add the transactions to your bank register. These imported transactions will now be available for allocation and reconciliation.

With the bank statement imported, the next step is to allocate transactions in MYOB. Navigate to the Bank Register and locate the imported transactions, which are typically marked as uncleared. Match these transactions to existing entries in your MYOB accounts, such as invoices, bills, or expense accounts. For unmatched transactions, you can create new entries directly from the bank register. Use the Match Transactions feature to automate this process where possible, as MYOB can suggest matches based on amounts and descriptions.

Finally, perform a bank reconciliation to ensure your MYOB records align with your bank statement. Go to the Banking menu and select Reconcile Accounts. Enter the statement’s ending balance and date, then compare the imported transactions to those in MYOB. Mark each transaction as reconciled once verified. Any discrepancies, such as missing or incorrect transactions, should be investigated and corrected before finalizing the reconciliation. This process ensures your financial records are accurate and up-to-date, providing a clear picture of your business’s financial health.

Matching transactions to existing records

When matching transactions to existing records in MYOB, the primary goal is to link bank transactions imported from your financial institution with corresponding entries already in your MYOB account. This process ensures accuracy in your financial records and simplifies reconciliation. Start by navigating to the Banking tab in MYOB and selecting Match Transactions from the dropdown menu. The system will display a list of unmatched bank transactions on the left and existing MYOB records on the right. Carefully review each bank transaction and compare details such as dates, amounts, and descriptions to identify potential matches. MYOB often suggests matches automatically based on similarities, but manual verification is essential to avoid errors.

To match a transaction, click on the bank transaction on the left and then select the corresponding MYOB record on the right. If the transaction matches an existing invoice, bill, or spend money/receive money transaction, MYOB will allocate it accordingly. For example, if a bank transaction corresponds to an unpaid invoice, selecting the invoice will mark it as paid. Ensure the amounts match exactly; if there are discrepancies, investigate further before allocating. MYOB also allows you to split transactions if a single bank entry corresponds to multiple records, such as a payment covering several invoices. Use the Split button to divide the transaction and allocate portions to the appropriate records.

In cases where a bank transaction does not have an exact match in MYOB, you may need to create a new record. For instance, if a payment or deposit is not linked to an existing invoice or bill, use the New button to create a spend money or receive money transaction. Once created, allocate the bank transaction to this new record. Be consistent with coding and categorizing these transactions to maintain uniformity in your financial data. If a transaction is unrelated to business operations, such as a bank fee, allocate it to the appropriate expense account.

MYOB provides tools to handle unmatched transactions efficiently. Use the Ignore function for transactions that do not require allocation, such as transfers between accounts. However, exercise caution when ignoring transactions, as this can affect your reconciliation process. For recurring transactions, consider setting up rules in MYOB to automate matching in the future. These rules can save time by pre-allocating transactions based on criteria like payee names or amounts. Regularly review and update these rules to ensure they remain accurate.

Finally, after matching transactions, proceed to the Reconcile step to finalize the process. MYOB will display the reconciled balance, and you can make adjustments if needed. Matching transactions to existing records is a critical step in maintaining accurate financial data in MYOB. By carefully reviewing, allocating, and reconciling transactions, you ensure that your bank statements align with your business records, providing a clear and reliable financial overview.

Creating and coding new transactions

When creating and coding new transactions in MYOB, it's essential to ensure accuracy and consistency to maintain a clear financial record. Begin by navigating to the Banking module and selecting the Spend Money or Receive Money option, depending on the transaction type. For example, if you're recording a payment to a supplier, use Spend Money. Enter the transaction date, which should match the date on the bank statement or invoice. Select the appropriate bank account from the dropdown menu to ensure the transaction is allocated to the correct account.

Next, choose the Payee or Payer by either selecting an existing contact from the list or creating a new one. If the contact is new, click New and enter their details, such as name, address, and ABN (if applicable). Once the payee/payer is selected, proceed to the Details section. Here, you’ll need to code the transaction to the correct account. For instance, if the transaction is for office supplies, select the Office Expenses account from the dropdown list. Ensure the account code aligns with your chart of accounts to maintain proper categorization.

In the Amount field, enter the transaction value. If the transaction involves tax (e.g., GST), MYOB will automatically calculate the tax amount based on the tax code assigned to the account. Verify the tax amount and adjust if necessary. You can also add a memo or reference number in the Memo field to provide additional context, such as an invoice number or payment description. This step is crucial for traceability and future reference.

For transactions involving multiple items or accounts, use the Splits feature. Click on the Splits button and allocate the total amount across different accounts or items. For example, if a payment covers both office supplies and utilities, split the amount between the Office Expenses and Utilities accounts. Ensure the total of the splits matches the transaction amount to avoid discrepancies. Once all details are entered, click Record to save the transaction.

Finally, reconcile the transaction with your bank statement to ensure it matches. Go to the Bank Register and locate the transaction. Tick the checkbox next to it and match it with the corresponding bank statement entry. If the amounts match, the transaction is reconciled. Regularly reconciling transactions helps maintain the accuracy of your financial records and ensures that all bank transactions are correctly allocated in MYOB.

Resolving unmatched or incorrect entries

When resolving unmatched or incorrect entries in MYOB, the first step is to identify the discrepancies between your bank statement and the transactions recorded in the software. Start by running a bank reconciliation report in MYOB to highlight any unmatched transactions. These could be transactions that appear on your bank statement but are missing in MYOB, or vice versa. Carefully review the dates, amounts, and descriptions to pinpoint the discrepancies. If a transaction is missing in MYOB, manually enter it into the system, ensuring it is categorized correctly to the appropriate account. Use the "Spend Money" or "Receive Money" functions, depending on the transaction type, and match it to the bank statement entry.

For transactions that are incorrectly recorded in MYOB, locate the specific entry in the transaction list or register. Access the transaction by navigating to the relevant account (e.g., bank account) and opening the transaction journal. Edit the incorrect entry by double-clicking on it, then modify the details such as the date, amount, or account allocation. Ensure the changes align with the bank statement to maintain accuracy. If the transaction was allocated to the wrong account, reassign it to the correct one. Save the changes and re-run the reconciliation report to confirm the correction.

In cases where a transaction is duplicated in MYOB, identify the duplicate entry and delete it. To do this, locate the transaction in the bank register, right-click on it, and select the "Delete" option. Confirm the deletion and ensure it does not impact other reconciled transactions. After deleting the duplicate, re-reconcile the account to ensure the changes are reflected accurately. Always double-check the reconciliation report to verify that the issue has been resolved.

If you encounter a transaction that cannot be matched or corrected easily, use the "Match to Another Transaction" feature in MYOB. This allows you to link an unmatched transaction to an existing one, which is useful if the transaction was split or recorded differently. Highlight the unmatched transaction, click on the "Match to Another Transaction" button, and select the appropriate entry to link them. Adjust the amounts if necessary and ensure the allocation is correct. This feature helps maintain a clean reconciliation without manually re-entering data.

Finally, for recurring issues with unmatched or incorrect entries, consider reviewing your data entry processes. Ensure that all transactions are being recorded consistently and accurately from the outset. Train staff on proper data entry procedures and regularly audit transactions to catch errors early. Utilize MYOB’s import tools carefully, as errors during batch imports can lead to discrepancies. By maintaining disciplined data entry practices and promptly addressing issues, you can minimize the occurrence of unmatched or incorrect entries in your bank reconciliations.

Frequently asked questions