Home » All Posts » Wrong Date On A QuickBooks Transaction?

Wrong Date On A QuickBooks Transaction?

Why is a “wrong” date on a QuickBooks transaction a problem?

If you find a transaction in your accounting records that doesn’t have the right date on it, it could be a significant problem! Why? Here are a few things to consider:

  • One of the first things that help you to know how you’re REALLY doing in your business is to post income actually earned as well as the related costs you’ve incurred to earn that income in the same time period. (This matching of income and cost is typically referred to as the “matching principle”).

    So if you have an incorrect date on a transaction, you end up with either income or costs posted into the wrong period (income and costs don’t “match up”). Then your financial accounting results may look great one month – and terrible the next. This can be really frustrating for owners and managers who need to see accurate financial information for decision-making purposes. So getting the dates right is important!
  • Why are Bad Dates in QuickBooks a problem?BUT, if you’ve already turned in your financial results for banking or tax purposes and then delete, modify, or add a transaction into that same period, you’re changing the underlying results behind your “official” financial reports. As a result, it could become very difficult to support reported results. Just imagine the possibility of an audit occurring 2-3 years down the road!
  • Plus, if you’ve changed your financial results behind the scenes, your tax accountant must pinpoint where your prior-period numbers have changed and fix the issue (extra time = extra co$t).
  • And remember…changes could impact paid or unpaid commi$$ions.

What To Do?

Investigate and gather information about the problem transaction:

  • Wrong Date on Quickbooks TransactionIs it in a current accounting period that’s not yet been reported to any outside parties?
  • Is it from a prior accounting period that HAS been reported to a lending institution or to your tax accountant?
  • How much is the amount of the wrong-date transaction? (I.e., Is it just a few dollars, a few hundred dollars, a few thousand, or a much larger amount?)
  • What is the impact of the dating error? E.g.:
    • Does it affect job costing and related calculations?
    • Will it increase or decrease the amounts of tax owed, or create a change in the prior-period owner’s equity balance?
    • Will you need to adjust someone’s commissions?

Proceed cautiously

Regarding corrections to prior periods:

  1. Unless you’re an experienced accountant, you should never make changes or corrections to prior (reported) accounting periods (regardless of the size of the transaction).
  2. If you believe a correction needs to be made, please get feedback and approval from an experienced accountant. (This includes adding, deleting, or changing the amounts of prior-period transactions.)

Corrections to current (“non-reported”) entries:

Proceed with Caution

If the amount of the wrong-date transaction in QuickBooks is fairly small and in the current accounting period, you can likely change the date.

  1. Generally, corrections to current periods can be made with the owner’s approval – but check to find out your internal policy on error corrections.
  2. In some cases, you may want to post a second, correcting entry in the current period.
  3. If the transaction is in the current period, but the amount of the transaction is a mid-to-large amount or has any impact on employees or outside parties, you should check with the owner and/or your accountant before deciding how to proceed.

The Biggest Thing To Remember

Don’t take the dating (or re-dating) of transactions lightly!

An incorrect date can have a number of repercussions, so as you enter transactions be careful to place correct dates on current entries.

If you do find an entry with the wrong date in your QuickBooks file don’t just “blow through” the correction process. You’ll be much further ahead if you investigate, think it through, and check in with the owner of the company and/or with your accountant before making date-related corrections.

Another Tip: Document Those Errors & Corrections!

After a few months, even those with incredible memories can have difficulty recalling the details of what happened to any specific transaction. So it’s a good idea to always document:

  • Bad Dates - What to RememberWhat you found.
  • When you found it.
  • Why you thought it needed to be corrected and the results of your research.
  • Your recommended correction.
  • Who approved it, and when.
  • When you made the correction.

Memos within the transaction plus a simple set of notes can be a real-time and reputation-saver!

Learn more about our construction accounting and manufacturing program classes and discover our job-cost support products!

From the Intuit Find a ProAdvisor website…
“Diane is always very prompt, professional, knowledgeable, personable, friendly, and a pleasure to work with. I would recommend her for all of your QuickBooks consulting needs.”