HOME / COMMUNITY Switch to knowledge base

Bulk change incorrect postings

It’s not an uncommon scenario, you’re bringing your accounts up to date and realise that you’ve been posting an expense to the wrong nominal code all year, you have 100s of invoices posted to “Office Equipment” when it should have been “IT Consumables”.

Before you had to either transfer the total as a single journal or manually change potentially 100s of invoices. the first option was always the more sane approach, although something of a compromise!

Introducing the recoding tool

From your chart of accounts page (Reports >> Chart of Accounts), you can now drill down into the ledger and move up to 50 items at a time in bulk using our new re-coding feature. Just select the applicable entries and click the button at the top Move to new code.

Once you click the button a dialogue will appear asking where you want to move these transactions to.

Click save and within a few seconds, the entries on the ledgers will have been updated, along with any corresponding invoices or payments.

Another use for this tool is to allow bank transactions posted to the wrong bank account to be relocated (assuming the currency is the same).

A few limitations

There are a few limitations to this tool but this should only affect a small number of scenarios.

  • Entries on purchase codes can only be relocated to other purchase codes, likewise for sales.
  • You cannot re-code entries made on control accounts (e.g. debtors, creditors, VAT etc), the core accounting system relies on these entries for various reporting requirements.
  • Bank entries can only be relocated to other bank accounts denominated in the same currency. E.g. you can’t bulk relocate entries in a EUR account to a USD account.

Enjoy!

Changing a catagory
Bulk change incorrect postings - further discussion
PAYE showing Asset Balance Sheet
Changing nominal account from 1001 to 5202?
Adjusting Stock Asset code 1001
Cost of sales and nominal accounts
Annual return - professional fees
Amending an invoice after a vat return
Moving my AA Cover payments
Capex Purchasing categories
How do I switch a nominal account in Direct Expenses to Purchases
Inventory analysis using nominal codes
Help! Tagged Dividend as Salary by Mistake. How to correct?
Quickfile using Bank account that I havenet set up?
Salaries not showing on P&L
Wrong sales category
Nominal Accounts - Change from General to "another" account
Can you alter the purchase category of invoices in bulk?
Ive accidentally allocated invoices to the wrong code
Reallocating misallocated expenses post vat submission
The Chart of Accounts
Unlocking VAT period
Changing a category of a purchase invoice
Re-categorising Auto PayPal Payments
How to delete duplicate bank account
Change purchase categories in bulk. VAT return has been submitted
Allocated an expense to the wrong account
Is bulk detagging possible?
Anyone got a few minutes to help a complete novice?
How to make Corrections
Bulk Move Mispostings
Banking Settings
Sales invoices not posting to correct category
Changing Nominal Code Entries
Move to new code
Categorising your purchases
Allocated to wrong Bank Account
Incorrect posting to director loan account
Merging bank account data in Quickfiles
Is there a way to undo a statement upload
Sales incorrectly allocated
Loan to Company
Mass Detag and Clear Chart of Accounts

I have a few queries about nominal codes. I run a antiques business, one of my expenses is restoration of stock. I’m not sure which code from the drop down I should use.

As I am on the margin scheme, this is a operating cost like electricity rather than cost of sale.

I suppose I could just use ‘cleaning’

Thanks

The precise code you use is less important than the general area on the P&L where it resides. “Cleaning” is usually used for cleaning costs associated with your business premises. I would say this is a general purchase (cost of sales), so I would create a new code on the Chart of Accounts as such.

I should add I’m not an accountant so it’s always worth qualifying this with an accountant first.

This is a great addition, reduces a monumental **** up to a mere inconvenience!

1 Like

Im looking to use this feature but the box is not appearing next to some nominal codes, is there a way to get it to appear that Im missing? I`m going through the chart of accounts.

Which code are you trying to adjust? Currently this bulk change tool is only applicable for purchase nominal codes, sales and bank codes. Control accounts (E.g. debtor, creditor, suspense, VAT etc) and some other codes may also be locked .

This topic was automatically closed after 6 days. New replies are no longer allowed.