Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello All,
Firstly, this is only 0.40 British pennies but it is haunting me in the books!
For a reason not entirely clear, on the final payslip of one of our ex-carers, QuickBooks calculated the PAYE, the wages were paid and the PAYE submitted as per normal. PAYE was calculated, in this example as £122.60.
Come next payroll (when the carer had left an no wages were due), the PAYE was calculated as -0.40 and this is the only entry on that payroll. So this sounds like on the last payslip, PAYE was 0.40 too much and that the carer paid too much by that amount to HMRC. So this was showing as the amount due which I duly paid in to her account (I like things to be straight).
However, my PAYE liability account either shows as 0.40 out now OR if I correct that to make it balance, my bank account shows 0.40 different to what Quickbooks says I should have. It says I should have 0.40 more in my account than what the bank balance is.
I am assuming I have incorrectly categorised this 0.40 somehow but my question is, how SHOULD this be recorded so that my bank balance is straight and my PAYE liability account is straight?
I feel like just putting the money in to the account but then that would send something else out.
I would be grateful if someone could please help and show me the error of my ways.
Thank you
Andrew
Just an update...
So I have got both the PAYE Liability and the Wage (Payment) accounts balancing and the Bank Account now shows the same as QuickBooks, but what I have done just doesn't sound right.
I have basically changed the transaction of the PAYE Liability to 0.00, set the Wage Expenses to 0.40 debit and the Payment is as it was at 0.40 credit.
Surely, I somehow need to record a minus of this 0.40 PAYE liability as otherwise there is no record of it as the previous payslip still shows a 0.40 extra liability. It is effectively a minus liability (or credit). But when I try to do this QuickBooks tells me something isn't right as the debits and credits are not balancing. If I get them to balance then the PAYE Liability account still shows 0.40 out.
So yes, it all balances but would still appreciate if someone could tell me how a refund, if you like, of PAYE liability on the next payroll should be dealt with.
Thanks again
Andrew
Let's investigate where the PAYE 0.40 extra liability came from, pezza72.
We appreciate you for coming up with a workaround to balance both the PAYE Liability, the Wage (Payment) accounts, and the Bank Account. To trace where's the 0.40 PAYE liability amount, we can run the P32 report. The Employment Payment Record report shows the amount due to HMRC for a given tax month. Then, the report will show the sum of the weeks for the relevant tax month if you pay weekly. Here's how:
Once we trace the amount, we can enter a journal entry with the PAYE liability account entered on one line. Then, the default debtors account (you may have this as 'accounts receivable) is on a separate line(s), with the respective employee entered in the 'name' field. You'll then be able to select the journal entry under 'outstanding transactions' on the receive payment screen of the invoices. We'd recommend consulting this with your bookkeeper or accountant first to ensure that this is recorded accurately.
When running payroll, journal entries are created for each employee and the liabilities you must pay to HMRC. The journals created affect your liability balances. The account Payroll Liabilities in QuickBooks has several sub-accounts to this account including HMRC, Pension, and Other Deductions:
If you need further assistance with this, please reach out to our Customer Support Team. They can pull up your account in a secure environment and help you with the PAYE adjustment. They can also provide your details about processing a refund of PAYE liability on the next payroll should be dealt with. Here’s how to get in touch with them:
You may read through these additional resources about this topic.
I've always got your back should you need assistance when doing payroll tasks such as running payroll reports, payroll year-end, and tax updates. Drop your reply anytime and I'll get back to you. Take care always.
Thanks for the reply @RCV
So this is the snippet of the P32 showing just the minus amount of PAYE following the final Wage and effectively reducing the total PAYE liability by 0.40
This is how I have the books at the moment, which as mentioned, is balancing. I can't seem to get it back to how it was when the books balanced but showed the bank account out by the 0.40 (typical!) as was going to show that setup too. Personally, (in my own head), this 0.40 should be on the usual opposite column in the JE against PAYE Liability to actually show as a negative liability, but whether I put a minus or I swap it between columns, it either will not let me bypass (as it doesn't balance the columns) or it accepts it but shows a 0.40 balance on the PAYE Liability overview in the COA. And to me there is no wage expense. It is just a refund (reduction) of PAYE liability with a payment I made back to the carer as she clearly paid 0.40 too much on the final payslip
So are you suggesting that I should have a Payment of 0.40 in the credit (as it is now), a 0.40 PAYE liability of in the credit as this was a reduction in liability from the last submission and then what you are saying is there should be some counter 0.40 in the debit recorded under another category?
Apologies if I have misunderstood, the debits, credits confuse me at the best of times, but with this kind of being the opposite of what would normally be a PAYE liability, that is confusing me more :)
Thanks
Andrew
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.