Skip to main content
H
HPS2022
January 31, 2024
Question

How do I apply 2 partial payments to 1 payroll check?

  • January 31, 2024
  • 1 reply
  • 0 views

Hi there,

 


I'm currently facing a dilemma and unsure how to resolve it. In our QuickBooks Online (QBO) system, one of my employees was incorrectly paid for overtime. He worked a total of 92 hours but received the base rate for all hours, instead of the regular rate for 80 hours and the overtime rate for the remaining 12 hours.

Upon discovering this error, I adjusted the payment for tax purposes and sent the additional amount owed via ACH. However, these two transactions now appear separately in my bank feed. I'm struggling to figure out how to link both payments to the original payroll check, as the system doesn't provide an option for this. Please note that they have different transaction dates.

Please help! I am unable to reconcile my books. 

1 reply

J
JamesAndrewM
January 31, 2024

Thanks for dropping by the forum and sharing the details of your concern. I'm here to share information and guidelines to help you clear this and reconcile your books.

 

In QuickBooks Online, matching two downloaded transactions into one is not possible. Instead, you can exclude these entries and manually clear the paycheck so you can reconcile your books without a problem. Here's how to exclude them:

 

  1. Go to the For Review tab.
  2. Select the checkbox for each transaction you want to exclude.
  3. Click Exclude.

 

Please refer to this article for detailed information: Categorize online bank transactions in QuickBooks Online.

 

You may visit these links to guide you on how to reconcile your account flawlessly: Reconcile an account in QuickBooks Online.

 

By following these steps, you can clear these transactions and reconcile your books effectively. If you have more questions about managing your transactions in QuickBooks Online, post them here in the forum. I'll be sure to answer them in any way possible. Have a great day ahead!

H
HPS2022Author
February 1, 2024

This won't resolve my issues as it still won't properly reconcile the account. The payroll check amounted to $1877.92, but it was initially recorded as $1778.49, resulting in a difference of $99.43. This discrepancy represents the amount I transferred to the employee the following month after rectifying the mistake. However, the October 2023 reconciliation is now off by $99.43 because the corrected paycheck now shows as $1877.92 instead of $1778.49. I hope this clarification is clear and not too complex.

I reached out to QBO support, but their assistance was not particularly helpful.

 

Unfortunately, I cannot edit the paycheck since it accurately reflects what the employee was paid, even though it was split into two different amounts paid on separate dates. Regrettably, this occurred in two different months, complicating the reconciliation process. Please inform me if there's any other way you can provide assistance.

G
GlinetteC
February 1, 2024

I appreciate you getting back and clarifying your issue, HPS2022.

 

I'm here to offer additional assistance to handle this transaction in QuickBooks Online so you can proceed with reconciling the account.

 

You can create a journal entry to fix this. Before doing so, I recommend seeking help from your accountant. They can provide options and ensure your books are accurate. Here's how:

 

  1. Click the + New button, then select Journal entry.
  2. Enter the necessary information.
  3. Select Save and close.

 

For more guidance, check this article: Create journal entries in QuickBooks Online.

 

Once fixed, you can continue reconciling the account to ensure your books are updated.

 

Furthermore, I'm sharing an article that offers businesses the benefits of accuracy, compliance, financial analysis, and record-keeping about your business and employees: Run payroll reports.

 

Please don't hesitate to post again if you have any questions about managing employees or handling payroll. I'm here to assist you.

Terms & ConditionsAccessibility statement