Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I create paychecks within QB,and the payroll taxes (e.g. social security, Medicare, unemployment...) are reflected on profit and loss reports correctly as expenses.
I make payroll tax payments through EFTPS, and record them as taxes. They also show up on P&L reports as expenses. This means payroll taxes are counted twice on P&L reports.
Could anyone offer a tip on how to handle this?
Solved! Go to Solution.
"Today in January 2019, I created a liability check, but dated it October 10, 2016"
Let's review: you are Catching up the bookkeeping. So, you date it the same as if you just did it = Your Date = the date you Paid it Online. Dates matter and need to match your reality.
"a few days before the downloaded transaction date."
Meaningless. What you have is proof that it actually and finally got to the bank and was processed. This date is Not Yours and you don't use it for your own financial records. It's an activity that you were hoping to see = verified that the EFTPS got processed. Now you will confirm that the Amount you entered into EFTPS is the same amount QB told you that you owed, because you Already have the entry in QB.
If you pay me by check in Nov 2018 and I didn't cash it until Today, you Spent that in 2018 and that is your 20148 business tax reporting expense. Banking Date is not Your perspective.
"how can I match this newly created liability check with the transaction downloaded in 2016?"
Is your Banking in QB fully reconciled? If not, then you have the EFTPS check, already. The "download" isn't even in the Banking Center, is it? If your banking is reconciled, you will Delete the wrong entry, because you just made it using the Right Function. It is no big deal to re-reconcile. You do all your housekeeping. Let's pretend that all of this is up to Dec 2017 and nothing beyond is reconciled, because you are Catching up all bookkeeping and taxes were never reported and are later. Once you fixed everything, you use the Dec 2017 bank statement's ending balance and date, you ignore the Beginning balance, since you know your housekeeping changed, deleted, and otherwise affected previously reconciled transactions. You Rereconcile to that ending balance for that date, and you see all the housekeeping entries are showing that you know previously were cleared, so you clear them now. You still get to a different of 0 and now you are On Track with the Replacement Transactions.
You can decide to Never Use banking downloads. They are a Helper function, to prereconciliation, as a way verify entries you made are on track = that is the Match function. And if your QB system, for instance, has entries differently, then there might not be a Match, but as long as the Amounts are right, you can mark the downloads selectively as Ignore = delete the download, I am not going to use it. Example: You decided to use Write Check to enter the Refunds to an employee but you wanted to list actual Vendor or Payee, and in reality, you wrote that employee one check. That means Banking Download won't be an exact match to Multiple Transactions but the Total is right. There are ways to use QB to prevent that, or you know the Values are right and you like your method = Ignore the one Check entry from Banking download. You still reconcile just fine. Or, I have a client that uses Receive Payment and wants each to post individually to the Checking account, even though she batches one large deposit. She won't use the method of Undeposited Funds to batch it, and she won't use the function the Add More Details, to match the batched deposit to individual open invoices. I won't fight her on this, because the Bank reconciles fine. Her method is crude, but it is Fine.
"In the future, I will create the liability check first before downloading corresponding transactions. I want to fix the existing problems first."
You don't use Download Banking historically. You manage your Banking. You make sure things are right, and Reconcile to each statement, working your way forward. You don't need Banking download at all. It's a Helper tool, not a requirement. Don't use a tool that makes More Work for you, for the historic housekeeping you need to do, now.
This is what you did Wrong: "and record them as taxes. They also show up on P&L reports as expenses. This means payroll taxes are counted twice on P&L reports."
You do your Bookkeeping of the Payment by using Pay Liabilities, and this is a Paperless Check and you put EFTPS because you need to indicate you Paid Online.
Never use Write Check or Bills for payroll in QB. You need to see that the Special Liability Check has a Liabilities Tab on it = it lists each Payroll Item you paid as taxes. Please see my attachment.
Thanks a lot for the explanation.
I think that I was moving in the direction you pointed out and this is why I also asked another question following this one, but probably I am missing the last piece to put to puzzle (for me) together. Let me explain the whole process for one tax payment:
As my understanding of your explanation, I did step 3 wrong. What should I to correct it?
Now you have this in Two Places. Let me restate: Do Not Use Write Check and you cannot accept this from Banking Downloads. I showed the image, that it is a Special Transaction with the listing of the Payroll Items.
The Payroll Items control the flow of the data in and out of your Accounts. And a critical difference is that "PERIOD" field on Liability checks = That is how your Payroll functions and payroll reporting keep track if you paid on time and paid the right amount and the Forms get filled in by the program from that info. Example:
Paychecks in Dec 2018, FICA is due and payable for you by Jan 15, and that means the PERIOD in the FICA pay liability check has to be Dec 1-31, for the system to understand that the Dec FICA was paid in Jan. That way, PERIOD does not overlap a month end, quarter end or year end, even though the Payment was made in Jan 2019.
These are not Banking. These are Payroll Activities and Functions.
Yes, step 4 = do your own Bookkeeping of the Liability Check, but this is not to be printed or sent; it is a Bookkeeping entry that this Pay Liability happened. Put EFTPS for the Check # = Paperless.
Yes, Step 3 is wrong if you did not already Make the entry using Payroll Center to Pay Liabilities. This is not Banking. It's Payroll.
Do step 4 before step 3. You cannot Match to something that does not exist.
Thanks a lot for the elucidation.
One key step that I missed is "Put EFTPS for the Check #". I could not find find what is shown on your screenshot, so I started to suspect we were using different versions of QB.
I have step 4 as you instructed and put its date a few days ahead of the downloaded transaction.
Now, please forgive my rudimentary question: how would I match this downloaded transaction with the liability EFTPS check?
Actually, I created the liability by trying to edit the downloaded check. I tried to change the account from Tax to Payroll Liabilities, then QB created a new liability check exactly as you described as far as I know instead of editing the downloaded transaction.
Hi there, @zipswich.
Allow me to join the conversation and help share some information about paying your payroll liabilities in QuickBooks.
If you've created a check on the Write Check page, you'll have to delete that check and follow the Pay Liabilities feature to create a check for the tax payment. Once you're done with the process of Paying liability, the Payment should show on Banking and will allow you to Match the transaction from the Bank.
I'll be here to help if you have other questions.
My image is an older Liability check, but the Point you needed to examine is the Liability tab. Your Write Check has an Items Tab. They are Not the same.
Your pop up error is warning you: You are trying to post to accounts Manually, but this Account you are trying to use is supposed to be controlled by Pay Liabilities.
You need to use Pay Liabilities. Not Wait for banking, but Make your own entry when you also Made your payment. Make your own entry, then Banking Download finds the match you already entered and this Match = Confirms that the amount you entered in QB and EFTPS are the same amount. Sometimes we make typos; you want the Match to confirm that what you entered into EFTPS is what QB showed you owed and what you told QB, "I paid this Online."
I have a New Image for you. It shows Where you need to do this from. Not from Write Check and not from Banking Download.
Thank you all.
I believe I got all your points and have created one liability check successfully. Everything looks right to me.
The only missing part that I did not explain well is the matching part.
Let me use one example to explain this. I created paychecks and paid taxex online back in 2016.
The online payment transaction was downloaded back in 2016. Today in January 2019, I created a liability check, but dated it October 10, 2016, a few days before the downloaded transaction date.
My question is: how can I match this newly created liability check with the transaction downloaded in 2016?
In the future, I will create the liability check first before downloading corresponding transactions. I want to fix the existing problems first.
"Today in January 2019, I created a liability check, but dated it October 10, 2016"
Let's review: you are Catching up the bookkeeping. So, you date it the same as if you just did it = Your Date = the date you Paid it Online. Dates matter and need to match your reality.
"a few days before the downloaded transaction date."
Meaningless. What you have is proof that it actually and finally got to the bank and was processed. This date is Not Yours and you don't use it for your own financial records. It's an activity that you were hoping to see = verified that the EFTPS got processed. Now you will confirm that the Amount you entered into EFTPS is the same amount QB told you that you owed, because you Already have the entry in QB.
If you pay me by check in Nov 2018 and I didn't cash it until Today, you Spent that in 2018 and that is your 20148 business tax reporting expense. Banking Date is not Your perspective.
"how can I match this newly created liability check with the transaction downloaded in 2016?"
Is your Banking in QB fully reconciled? If not, then you have the EFTPS check, already. The "download" isn't even in the Banking Center, is it? If your banking is reconciled, you will Delete the wrong entry, because you just made it using the Right Function. It is no big deal to re-reconcile. You do all your housekeeping. Let's pretend that all of this is up to Dec 2017 and nothing beyond is reconciled, because you are Catching up all bookkeeping and taxes were never reported and are later. Once you fixed everything, you use the Dec 2017 bank statement's ending balance and date, you ignore the Beginning balance, since you know your housekeeping changed, deleted, and otherwise affected previously reconciled transactions. You Rereconcile to that ending balance for that date, and you see all the housekeeping entries are showing that you know previously were cleared, so you clear them now. You still get to a different of 0 and now you are On Track with the Replacement Transactions.
You can decide to Never Use banking downloads. They are a Helper function, to prereconciliation, as a way verify entries you made are on track = that is the Match function. And if your QB system, for instance, has entries differently, then there might not be a Match, but as long as the Amounts are right, you can mark the downloads selectively as Ignore = delete the download, I am not going to use it. Example: You decided to use Write Check to enter the Refunds to an employee but you wanted to list actual Vendor or Payee, and in reality, you wrote that employee one check. That means Banking Download won't be an exact match to Multiple Transactions but the Total is right. There are ways to use QB to prevent that, or you know the Values are right and you like your method = Ignore the one Check entry from Banking download. You still reconcile just fine. Or, I have a client that uses Receive Payment and wants each to post individually to the Checking account, even though she batches one large deposit. She won't use the method of Undeposited Funds to batch it, and she won't use the function the Add More Details, to match the batched deposit to individual open invoices. I won't fight her on this, because the Bank reconciles fine. Her method is crude, but it is Fine.
"In the future, I will create the liability check first before downloading corresponding transactions. I want to fix the existing problems first."
You don't use Download Banking historically. You manage your Banking. You make sure things are right, and Reconcile to each statement, working your way forward. You don't need Banking download at all. It's a Helper tool, not a requirement. Don't use a tool that makes More Work for you, for the historic housekeeping you need to do, now.
Thanks a lot for the detailed transaction.
I think the main point that I was missing is "You don't need Banking download at all. It's a Helper tool, not a requirement.". In this case, I will just delete the downloaded transactions and date the liability checks the same date as their corresponding downloaded transactions.
Yes, so far the banking register has matched my bank account records perfectly. I have always made sure this. I am used to perfect matching. The downloaded transactions have matched paychecks, invoices perfectly so far.
I have just caught up with one quarter by creating four liabilities checks to replace 4 downloaded transactions (state UI, state withheld, Fed 940, Fed 941). It looks good so far.
Many thanks again.
Glad to hear everything works well on your, @zipswich.
It’s great to hear QuickBooks is taking the headache out of recording your payroll tax payments. QuickBooks is committed to providing you with tools that make financial tracking and tax preparations as easy and automated as possible.
We’ll be sure to keep adding features to this software so it becomes a more versatile tool for you. Keep an eye on our blog for announcements: https://intuit.me/2L2zqTv.
If there are any program features you’d like to get more familiar with, feel free to visit our Community page. I’m always here to help.Wishing you continued success!
Thank you @IamjuViel
I wanted to add that for the last quarter I created payroll liability checks before downloading corresponding transactions from the bank, and QB matched the downloaded transactions with liability checks correctly. Everything works perfectly now.
That’s music to my ears, @zipswich.
Nothing makes us happier than hearing QuickBooks is making your life easier. It is my priority to make sure all the program’s features run smoothly for you.
Our Community articles have tips on how to set up all of the app’s features, so be sure to check them out in your spare time: https://community.intuit.com.
Always feel free to visit us here in the Community if you have question about managing your bank transactions and tax payments. I’m always here to lend a hand.
This is great: "I have just caught up with one quarter by creating four liabilities checks to replace 4 downloaded transactions (state UI, state withheld, Fed 940, Fed 941). It looks good so far. "
Glad to help.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here