I recognize the benefit of having the payroll journals posted automatically each month, @mattymoo. Let me give some ideas as to why it doesn't post in some cases.
There are a couple of things you'll need to consider to find out why you're getting the error message indicated above. Here is the list:
- Make sure that the "Close the books" feature is disabled for the month of November. If not, see this guide to turn it off: Close your books in QuickBooks Online.
- Make sure that their "Net pay account" is mapped as a foreign currency account under payroll settings.
- If migration from QuickBooks Desktop is done, make sure that the old payroll liabilities and payroll expenses accounts are renamed and have "desktop" at the end.
After going through each step, you may try to re-run the payroll month and see if it posts the data you want. If not, I recommend creating another dummy journal entry to any accounts for 0.01£. Ensure to use a transaction number that has never been used before in both QBDT and QBO.
Once done, try to run the payroll again and see if it shows the journal created. Don't forget to also delete the dummy journal to avoid messing up the account. Lastly, make sure to enable the "Warn when a duplicate journal entry number is used" option. This prevents you from using the same journal entry number.
Here are also some additional modules that you may find helpful when keeping track of and managing payroll transactions in QuickBooks.
Keep in touch if you need more help with payroll or QuickBooks in particular. We're available 24/7 to back you up. Take the best care always and don't overwork yourself!
