Frequently Asked Question

UnAllocating Accounting Journals
Last Updated 2 years ago

UnAllocating Accounting Journals in TBS

If you have created a (Sales or Purchase) Journal and you wish to 'undo' it, this shows you the relevant way to deal with that situation.

Taking the following as our example:

image

You can see that there are two entries which make up this journal, and we can see the 'parent' transaction number in the 2nd Ref column in the transactions list (the lower list) along with the value utilised for this line

In order to 'undo' this journal, we need to work our way through each entry of this list, and reverse the allocated value as shown in our original list here

So going to the Sales Ledger entry of the last line in our transaction list (63040) :

image

We can see that there is 0 outstanding on that line, and we want to change that to still show 18148.50 outstanding (the value of the entry in our starting list) - so we need to Edit this entry :

image

Note : any changes to ledger entries does require that these entries are 'Active' so if you notice that one of the ledger entries you are editing shows as not Active, you should also click on the Active box to make it active once more.....

You will see that the 'Allocated' value shows as 18148.50 - and we need to reduce this by 18148.50 (this is the 'reversing' effect of the undo procedure that we are trying to achieve) so set to 0 and save :

image

Now you will see that the entry for 63040 is showing as outstanding once again, so we need to go to the other entry from our original list (63042) :

image

Again if we edit this entry, you will see that the 'Allocated' value shows as -18148.50 - and we need to reduce this by -18148.50 so set to 0 and save, and now back at our original entry - we need to delete the two transactions from the lower list so they are zapped / undone !! :

image

Having highlighted both of the transaction lines, we can use the 'Delete' button to remove them :

image

Which is confirmed by having no lines left in the transaction list :

image

Finally, now we have undone the individual allocations which were made as a result of the journal, and removed the transaction entries so they will not get added to the general ledger at month end, we now need to make sure that the journal entry itself has no value :

image

Here you will see that the Value and Allocated values are both 0 - so there is nothing more we need to do, we have 'undone' the allocations which that journal had made.....if there *was* a value showing (perhaps a payment and an invoice with not quite matching totals) then having undone the allocations we would need to set the Value and Allocated values of the journal ledger entry both to 0 and then save.

Please Wait!

Please wait... it will take a second!