Share this content
0
142

TAS Books 3. Allocating supplier payments

Current bank reconciliation adds old payments

Didn't find your answer?

Search AccountingWEB

Lost my sole trader bookkeeper suddenly so trying to learn to do my own books.  So far, so good. I have hit a slight problem. TAS support are good only if it's a software issue and are reluctant to help outside of this.

I have found old supplier invoices which appear to have been settled but still show on Purchase Ledger Aged Invoice Analysis so I allocated and paid with their payment date outside of current month and year.  However they now are 'posted'? to Reconcile Bank Account and are not reconciled.  If I do reconcile then their amounts show as credit to bank which, of course, is incorrect.  How do I reconcile these old payments without adding to current period.

I can show a screen capture example if only I could find a way to do so.

Replies

Please login or register to join the discussion.

13th Jun 2019 12:44

I think you possibly have a bigger problem that can't just be solved by entering a bank payment. My suggestion is if the bank reconciles to your bank statement but you believe these invoices have been paid then the original bank payment was probably incorrectly allocated. You should search in TAS in the bank account nominal ledger to try to find the original payment as I would imagine that this has been allocated incorrectly in one of the following ways:
1) Posted to a duplicate invoice.
2) Posted to profit and loss account directly rather than allocated to the invoice.
3) Posted to another invoice for the same amount.
4) The final option is that the invoice may not have been paid at all.

I can't give any advice on the software as I haven't used TAS. I understand it's quite an old software that isn't being supported by MTD.

Thanks (0)
avatar
13th Jun 2019 15:26

Thanks for the suggestions. Problem is that even for one supplier there are eight unreconciled invoices. The odd one I could hack out but it looks like there will be many more.

I'll try and follow your advice as best I can nut TAS does no appear to have a Bank NL.

Thanks (0)
to Fopetesl
13th Jun 2019 16:59

TAS must show a bank nominal ledger of some kind maybe it’s called general ledger or account transactions.

Thanks (0)
avatar
to danstopp1
16th Jun 2019 11:41

danstopp1 wrote:

TAS must show a bank nominal ledger of some kind maybe it’s called general ledger or account transactions.


OK, think I understand. There is a NL 1800-100 Yorkshire Bank C/A (Current Account).
However if I print an Audit Trail it doesn't seem to help me resolve the issues unless I miss something.

Is there a way of adding a picture to my posts? Might help explain the issue more clearly.

Thanks (0)
avatar
By jcace
13th Jun 2019 15:55

You could try running your aged creditors ensuring the option to check each transaction is ticked. This should ensure that the invoices showing as unpaid are indeed unpaid in TAS.

Thanks (0)
avatar
to jcace
16th Jun 2019 11:49

jcace wrote:

You could try running your aged creditors ensuring the option to check each transaction is ticked. This should ensure that the invoices showing as unpaid are indeed unpaid in TAS.


OK, I did that but to my uneducated mind it's not clear whether they are paid. I guess you mean on TAS rather than the creditor since I can see that some suppliers must have been actually paid otherwise I would know from their current statements.

I did ask TAS support why some entries are in red, some in blue but they shrugged it off as no consequence.

Thanks (0)
Share this content