Otherwise, your next best bet to remove unneeded downloaded transactions is to check off the unmatched transactions in the Banking Feeds Center, click the down arrow next to Batch Actions and select Exclude Selected. So hopefully you have a QuickBooks ProAdvisor as an accountant user whom you can contact to undo your bank reconciliation if needed. If you create an accountant user for yourself to work around this problem, be aware that Intuit periodically searches for accountant users with no clients and removes them. Unfortunately if you want to fix matched transactions from prior reconciled periods in QBO, the “undo last reconciliation” command is only available to accountant users. You‘d be surprised at the errors you’ll catch if you do it this way. Once you have all the monthly reconciliations completed but not finalized, go back into each one and finalize it. The way around this problem is to complete the monthly reconciliations for each bank and credit card account, but do not finalize them until you have them all figured out. So you add it, creating a duplicate transaction.Ī Solution to Stop Adding Transactions Twice Instead the feed indicates you should add it. Because you already finalized the checking account bank reconciliation, a transfer of cash from checking to the credit card does not show up as matched on the credit card feed. You click to refresh the credit card feed (sometimes the feed does not automatically update) and all the latest transactions download. For example, you finalize the bank reconciliation for the checking account then proceed to the credit card account. If you completely reconcile one bank account for the month then move on to reconcile the next bank or credit card account, you run the risk of adding the same transaction twice. So the idea is to add the transaction in one account and then match the transaction in the other account. You only need to add the transaction one time to affect BOTH accounts. QBO will download the transaction in the Banking Feeds Center for each linked account. Transfers are transactions that affect two balance sheet accounts such as two bank accounts or a bank and a credit card account. It is all too easy to click to add these transactions which will create duplicate entries in your books. The danger here is that the transactions will change from suggesting “Match” to suggesting that you “Add” them. Once you complete and finalize the bank reconciliation, QBO will no longer be able to match these transactions to already entered transactions. The downloaded transactions, however, instead of being cleared out as you click to match them, will remain in the Banking Feeds Center. If you do NOT match downloaded checks in the Banking Feeds Center to checks already entered, then you can still reconcile your bank account in QBO by manually checking off the items that cleared the bank. QBO will mark them as cleared so when you do the bank reconciliation in QBO you won’t need to do the tedious work of checking off each cleared item against the items that cleared per the bank statement. Matching downloaded transactions with those already created will help enormously with the bank reconciliation process. QBO knows this, too, and in the Banking Feeds Center QBO will propose matching the downloaded check to the one that was already created. You obviously don’t need to post it again from the downloaded bank transactions. If you create a check in QBO so you can print and mail it to the vendor, then that check is already posted to the bank account as well as to the expense or other account affected. We will outline two common scenarios below. One way duplicates can arise is by not properly matching downloaded transactions in QuickBooks Online (QBO) to transactions that are already created in the software. The duplicate entry will, of course, never clear the bank and will simply sit there forever until someone cleans it up. The first instance of the transaction would have cleared on a prior bank reconciliation. If you see transactions with a date older than the prior month or that do not look right, it’s possible they are valid outstanding items (and if so someone needs to get on the phone to ask people to cash their checks) or you could have errors such as duplicated transactions.
Look closely at the list of outstanding items (those transactions that had not cleared the bank as of the bank statement date). Do you sometimes discover transactions entered into your nonprofit organization’s QuickBooks more than once? Twins are cute, but not in your books! Duplicate transactions cause your financial reports to be inaccurate and can be time consuming to fix.Ĭlues that you have duplicate transactions can be found in your monthly bank reconciliation.
0 kommentar(er)
