Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
So After running the payroll and creating the journal entries, I am unable to match the payroll payments from the bank feed to the journal entries. Was advised the exclude the payments from bank feed but now cannot reconcile the bank as payments are missing. If i try add payments in bank feed, it will not find the journal entries to match against. Suggestions please? Quickbooks online with standard payroll
Solved! Go to Solution.
Hi Dawn,
As the journal is trying to match to multiple smaller payments, if there's no automated match showing it's easier to exclude these transactions as the payments are already accounted for.
The 'net pay' amount line on the journal is the gross amount minus tax and other deductions - does this box match the value of all payments? These values should match exactly and in which case you can exclude and reconcile the account.
Thanks
Hi Dawn,
Thanks for your post and welcome to the Community. :waving_hand:
Is the journal posting to the correct bank account on the same date as the payments, and do the total amounts of the payments match the 'Net pay' amount on the journal? 🧐
If the amounts match, it's fine to exclude these payments from the banking. If not, you may need to check if there were any under/overpayments.
The journal entries are not coming into the match option. I have checked in the settings and all journal entries are from the same bank account just unable to locate them from the banking screen. The net pay and tax would add up to the total amount of pay.
Hi Dawn,
As the journal is trying to match to multiple smaller payments, if there's no automated match showing it's easier to exclude these transactions as the payments are already accounted for.
The 'net pay' amount line on the journal is the gross amount minus tax and other deductions - does this box match the value of all payments? These values should match exactly and in which case you can exclude and reconcile the account.
Thanks
I also have this problem but excluding the payments wouldn't work. In order to make Quickbooks match the bank then these need to be reconciled. However the journal still shows up as a liability. Is it a matter of amending the journal once the salaries payments have been made. Totally confused :\
Thanks for joining in this conversation, @Sineado. I've got you some information about matching your transaction in QuickBooks Online.
When creating journal entries to match your downloaded transactions, you'll need to ensure that the account is matched with the bank.
We can open the transaction journal to check which account goes under the Debit and Credit column.
Here's how:
From there, you may copy the accounts used and update your journal entry. Once your journal matches the transaction, it'll show "1 record found" under the Category Match column on the Banking page.
Read through this article for more information: Add and Match Downloaded Banking Transactions.
Come again and update me here so I can help you further if you have additional concerns.
Please I have this same problem and I don’t know how to solve it. I am in the middle of my company tax return.
This problem make my profit and loss account to be incorrect it shows that my expenses doubled my total income because of double entry.
QuickBooks picks salary expenses from my Tide bank and also picks same expenses from my QuickBooks payroll journal which now create a double expenses.
Any help will be appreciated as this is giving me a big headache
Hello PLANETOFPRO,
Welcome to the Community page,
Are you already matching the payments in the bank after the payroll after this is produced first?
No, I am using Tide bank account and no option to match payment to payroll in Tide bank account.
Please I need a solution as this makes my company Expenses to be more than income.
Jumping in to help you correct your expense amounts, PLANETOFPRO.
You can undo the categorisation of the downloaded payroll transactions. Then, exclude them from your bank to avoid duplicate expense records. Here's how:
Once done, follow these steps on how to exclude them:
Here's an article about this for more details: Exclude a Bank Transaction you Downloaded into QuickBooks Online.
Let me also share these articles for additional references:
Please don't hesitate to reply to me and share updates if you're able to sort out the expense amounts in your financial reports. The Community is always here if you need anything else.
Thanks so much for your help so far, I have followed your guide, my Profit and Loss account seems to be correct now. but unfortunately My bank account Balance is different from the balance in QuickBooks ( QuickBooks is Much higher ). please how do I sort this out? any help will be highly appreciated .
Many thanks
Hello Planetofpro, So there is a couple of different reasons why the amounts show differently so it could be due to duplicate recorded transactions also matter, you can also check if the opening/beginning balance for the bank in the chart of accounts is correct, also if you have any missing income/expense transactions as well. If you haven't already done it, you could also do a reconcile for the account.
Hiya,
The opening balance for the bank in the chart of accounts is different to QuickBooks balance . I thought this should automatically change after I excluded all the duplicate transactions from payroll payments. QuickBooks seems to difficult than I thought and not user friendly. I pray I get this sorted as soon as possible and move my business away from QuickBooks. I don't want Hmrc's problem.
Please I can I sort this out. I don't mind putting a call through
I'll provide more details to address this issue, PLANETOFPRO.
QuickBooks and bank balance doesn't match due to the following reasons below:
I understand how important it is for you to match their balance to prevent any problems during tax season. The QuickBooks balance is affected by all entered transactions, including the ones you haven't reviewed yet. While the bank balance is dependent on the transactions cleared by your financial institution.
For example: Your customer pays you instantly, you've created a sales receipt and then deposited the fund into QuickBooks' bank register. Since you've recorded a money in transaction, your QuickBooks balance will immediately increase. Your bank balance will remain unchanged, though, as it could take up to 48 hours or more for the banking institution to process the transaction.
To ensure your books is accurate, please consider reconciling your account as stated colleague Ashleigh1 above. Before proceeding, you can manually clear the payroll journal entry directly from your bank register since you've excluded the downloaded payroll payments.
Here's how:
I've included this article as a guide for future use if you run into a problem reconciling your accounts: Fix issues at the end of a reconciliation in QuickBooks Online.
Feel free to add any detail below if you need further assistance fixing balances in QuickBooks. I'll be here to help you.
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.