Child pages
  • Duplicated transactions

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

If you've entered a transaction twice, delete one of them. If a transaction has been matched, allocated or reconciled, you'll need to unmatch, undo the allocation or unreconcile it before it can be deleted.

Learn more:

To delete...see...
an invoiceDeleting invoices
an invoice paymentCustomer payments
a billDeleting bills
a customer returnCreating customer returns
a supplier returnCreating supplier returns
a spend money transactionSpend money
a receive money transactionReceive money
a payChanging or deleting a pay
a general journal entryGeneral Journals

Bank feeds

If you allocate a bank feed transaction instead of matching it to an existing transaction, you'll create a duplicate transaction.

To fix this:

  1. Undo the allocation (click the X for the allocated transaction on the Bank transactions page).
  2. Match the bank feed transaction to the existing MYOB Essentials transaction.

Learn more about allocating and matching transactions.

Duplicated transactions from imported statements

If you've imported a bank statement and notice you now have duplicated transactions in MYOB Essentials, it's likely caused by importing a bank statement which includes transactions which have already been brought into MYOB Essentials via bank feeds.

To fix this, you'll need to delete the imported statement, then download and import a new bank statement with an adjusted date range.

UI Expand
title1. Delete the imported bank statement
  1. On the Bank transactions page, click the dropdown arrow next to the Import Statements button and choose View Import History.
    dropdown arrow clicked with Import History option shown
    The Import History page appears.
  2. In the Bank account list, select the account you want to delete an imported transaction for.
  3. Click the icon in the Action column for the statement you want to delete. The Bank Statement Transactions window appears, displaying a list of all the transactions in the statement, and their allocation status.
  4. Click Continue. A message appears, displaying a summary of the statement you’re deleting. Note that if the statement you’re deleting contains transactions that fall within a locked period, you won’t be able to continue until you’ve unlocked the period.
  5. Click Delete. The statement is deleted, and the bank transactions are removed from MYOB Essentials.
UI Expand
title2. Download and import a new bank statement
  1. Download a new bank statement from your bank, ensuring the date range doesn't include transactions already in MYOB Essentials.
  2. Go to the Banking menu and choose Bank transactions. The Bank transactions page appears.
  3. Click the Import statements button at the top right of the page. The Import bank or credit card statement section appears.
    Bank transactions page with import statements button highlighted
  4. In the Bank/Credit Card Account field, choose which account you want the imported transactions to go into. 
  5. Click Choose file
  6. Find the statement file you want to import and click Open. The Bank transactions window reappears, showing the file name of the statement you chose.
  7. If you’re importing a .QIF format statement, select a Date format if using QIF from the list.

    UI Text Box
    typenote

    .QIF date format

    The date format (dd/MM/yy or MM/dd/yy) must match the format used in the imported statement. If it doesn’t, the statement won't be imported. If this happens, check what format your bank uses when creating the statement file, or open it in a plain text editor and look at the dates, then try importing again.

  8. Click Import Now to import the statement data into the account. A message appears at the top of the screen, telling you how many statement lines were imported successfully.
HTML
</span>
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namemagenta
titleRelated topics
HTML Wrap
classsidebarlinks

Working with bank transactions

Import bank and credit card statements

Deleting imported bank statements

Customer overpayments

Panelbox
nameyellow
titleFrom the community

RSS Feed
titleBarfalse
max5
showTitlesOnlytrue
urlhttp://community.myob.com/myob/rss/search?advanced=false&filter=location&q=duplicate+transactions&location=forum-board%3AEssentialsAccounting&allow_punctuation=false

HTML Wrap
classmorelinks
More »