cancel
Showing results for 
Search instead for 
Did you mean: 
rhdsfr
Level 1

Editing Date in Quickbooks for Tax Purposes

I made a wage payment via check to an employee who deposited it on 12/30/2023 but it did not clear the bank until 2024. How can I change this bank transaction in QuickBooks in order to file their 1099 accurately? Can I change the date on the transaction to reflect 2023 so that it comes up in the reports for the year?

10 Comments 10
JaeAnnC
QuickBooks Team

Editing Date in Quickbooks for Tax Purposes

Welcome to the QuickBooks Community, @rhdsfr

 

Currently, we're unable to edit the date of the transaction in the bank feed. However, we can exclude it and manually record the entry directly into the register. Here's how:

 

  1. Go to the Gear icon and select Chart of Accounts.
  2. Locate the bank account, then click View Register.
  3. Click the Add expense dropdown and select Check.
  4. Enter the necessary details and select Save.

 

After creating checks to pay for expenses, you can print them directly in QBO. Before doing so, be sure to configure the print settings to guarantee they align correctly.

 

Keep in touch if you need further help with checks in QBO. The Community is here to assist anytime. Take care, and have a good one.

BigRedConsulting
Community Champion

Editing Date in Quickbooks for Tax Purposes

RE: Currently, we're unable to edit the date of the transaction in the bank feed.

 

That is the craziest thing I've heard about QuickBooks Online in awhile. Does anyone there at Intuit know anything about accounting?

 

The date a check clears the bank is literally meaningless. The date the check is written - the date on the face of the check - is what counts for financial reporting. It doesn't matter if the recipient sits on it for months before cashing it - it's still the date on the check that matters.

 

That QB Online doesn't let the customer change a check date from the wrong date to the right date to fix it is literally incredible - not in a good way.

 

This is yet another reason to use QuickBooks Desktop.

rhdsfr
Level 1

Editing Date in Quickbooks for Tax Purposes

Agreed, but aren't they discontinuing Quickbooks Desktop?

Kimberly03
Level 1

Editing Date in Quickbooks for Tax Purposes

I heard that it was too, because when I inquired about it they said it was no longer going to be used. Now I have the online and I am having the same problems with checks and it is throwing off my 1099s. I don't know how to fix or get those to be accurate now. Help needed!!!

Thanks in advance, I am new to the Quickbooks world.

Kimberly03
Level 1

Editing Date in Quickbooks for Tax Purposes

Does this not mess with balancing the statements by changing the dates? I am having the same problem with getting the 1099s to be right since it is technically consider for that date of 12/30/23 and the bank feed is showing up in January 2024 and not being included.

SarahannC
Moderator

Editing Date in Quickbooks for Tax Purposes

Hello there, Kimberly03.

 

Allow me to join the conversation and share details about preparing the 1099 form in QuickBooks Online. 

 

When the check date differs from the bank cleared date, you should still always rely on your bank statement. Then, follow the date to which the transaction pertains. Reconcile the date based on your bank statement

 

If the check date needs to be corrected, you have the option to modify the transaction date in QuickBooks. Here's how:

 

  1. Go to the Transactions menu.
  2. In the For review tab, find the transaction.
  3. Modify the transaction date.

 

Note: Be very careful when doing this since it might cause discrepancies between your bank statement and QuickBooks records. I advise seeking guidance from an accountant to receive the best advice on managing date changes.

 

Then, here's an article about creating and filing 1099s in QuickBooks Online: Learn how to prepare and file your Federal 1099s.

 

I'll be around if you need more help. 

usertia
Level 1

Editing Date in Quickbooks for Tax Purposes

How can I make my 1099 balance when the final payment was not a check but a direct deposit instead. It was submitted but because of the holiday did not post to QB until 1/2/24 but it for sure needs to be on his 2023 1099...Help lol 

BigRedConsulting
Community Champion

Editing Date in Quickbooks for Tax Purposes

@usertia 

If the payment didn't happen until 2024, then it does not belong on a 1099 for 2023. So, you shouldn't do anything.

usertia
Level 1

Editing Date in Quickbooks for Tax Purposes

What sucks is that it is a flow through from one company to the person. Money comes in to me, I pay it out. We didn't receive the money until like the 28th. I entered it to pay him, and it didn't post til 1/2. So now I have it on my reports but not his. Hindsight I will cut a manual check next time but was hoping to figure out something with this.   

Kimberly03
Level 1

Editing Date in Quickbooks for Tax Purposes

I haven't reconciled the statement so I edited my date to make it work to do my print outs and then went back in to switch back to the original bank date. Side note these are hand written checks but for those who bank at my bank cleared that night and are on the December statement. So remember to allow at least 2 or 3 days for other banks and if it's a Friday those don't clear till the next business day watch for holidays. It's one of the cons to the online version. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us