Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
AB566
Level 1

What is the best solution

I worked with a QB expert to correct our mapping of our PFML and get it correctly flowing into our liabilities. He then had me recreate paychecks with the correct deductions as some were incorrect (so our w-2's0 would reflect correct information). After recreating, he had me delete the checks that were already reconciled in January and February and now the deleted checks are showing in the previous reconciliation discrepancy report, and the recreated checks (not resubmitted for payroll- just corrected so our w-2's will reflect correctly) are showing unreconciled in the reconciliation detail.  Now my check register is completely off dollar wise! I am trying to figure out the best way to get everything corrected. Should un-reconcile the previous months and reconcile the recreated checks or is there a better and more efficient way to get everything back so my check register is correct? Or what are the best steps. I tried to reach back to the person helping me and have not gotten a response. Please help! 

6 Comments 6
ZackE
Moderator

What is the best solution

Thanks for getting in touch with the Community, AB566. I appreciate your detailed information.

 

To get everything back to where your check register is correct, you'll want to try manually reconciling the re-created checks in the register.

 

Just as you'd balance your checkbook, it's important to review your accounts in QuickBooks to confirm they align with the actual bank and credit card statements. When reconciling an account, you compare the transactions with the ones on your bank and card statements. If they match, you knowthe accounts are balanced and accurate.

 

Initially, you'll want to perform a backup of your company file if you haven't yet.

 

You'll also need:
 

  • Your bank or credit card statement. Check the beginning and ending balances, and the statement's end date.
  • All transactions for the bank statement period you plan to reconcile entered into QuickBooks and on your statement.
  • To review the opening balance if you're reconciling the account for its first time.

 

Once you have your bank statement, you can start reconciling.

 

Here's how:
 

  1. Go to Banking, then Reconcile.
  2. In the Account field, choose an account you want to reconcile.
  3. Your Statement Date is automatically filled in. This is usually 30 or 31 days after the previous reconciliation's statement date. Make sure this is the same as your end date on the statement.
  4. QuickBooks also automatically enters a Beginning Balance. It uses the ending balance from your last reconciliation for this amount. Be sure this matches the beginning balance on your statement.
  5. Enter the Ending Balance from your statement.
  6. Enter any Service Charge or Interest Earned that hasn't been entered in QuickBooks yet.
  7. Select Continue to open the Reconcile window.

 

If your beginning balance doesn't match the statement, there's a few tools to help you:
 

  • Click Locate Discrepancies - This gives you reports you can use to find discrepancies and other reconciliation issues.
  • In the event you still have issues, you can review our fix opening balances or fix beginning balances articles.
  • If you need to start over fresh, you can consider using your Undo Last Reconciliation option.

 

You can learn more about manually reconciling by reviewing our Reconcile an account article.

 

Please feel welcome to send a reply if there's any additional questions. Have a wonderful Friday!

AB566
Level 1

What is the best solution

Thank you for your response. However this does not appear to be the answer to what I have going on. 

AB566
Level 1

What is the best solution

Thank you for your response. I think my explanation is not fully clear, and I don't think this will help in my situation. I have been trying to resolve this whole PFML issue for weeks with regular QB support and then Robert helped me to get it flowing to liabilities but it created a a mess with my check register and the recreated checks. I am hesitant to try anything without making sure it is what needs to be done as this has been such a headache. I have reached out to the person who helped me numerous times without response. 

ZackE
Moderator

What is the best solution

Thanks for getting back with the Community, AB566.

 

To make the corrections you're looking to make, you can consider using the steps in our Adjust payroll liabilities article. I'd initially recommend checking with an accounting professional and performing any steps under their guidance if you feel it's necessary.

 

If you're in need of one, there's an awesome tool on our website called Find a ProAdvisor. All ProAdvisors listed there are QuickBooks-certified and able to provide helpful insights for driving your business's success.

 

I've also included a detailed resource about reconciling which may come in handy moving forward: Learn the reconcile workflow

 

Please don't hesitate to send a reply if there's any additional questions. Have a great Friday!

AB566
Level 1

What is the best solution

I'm trying to figure out how the qb support did not know that having me delete and recreate would create so many issues. Is there anyone who can connect with me on Monday to help figure this out? As it appears that every solution I have received from Qb's has created another issue. I would love to try to get resolution without having to pay my accountant to fix. Thanks for any help you might be able to get me. Perhaps Robert would helped me would be willing to call and help me finish this. Thank you!!

cody_a
Moderator

What is the best solution

@AB566 It sounds like a lot of extra work to delete and replace those paychecks, and I want to make sure your register balance and reconciliation get back on track quickly. Since the previous steps haven't quite landed you where you need to be, I'm bringing in our Next Level Help team to take a closer look at this for you.

 

Our experts will review your recent Community comments and support history to understand the full scope of the mapping changes and the current discrepancy. You can expect one of them to reach out to you within 1-2 business days with a clear plan to resolve the balance and finalize your reconciliation.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us