Forum

• # 82094
• Fri 20 Apr 2012 06:24 AM

Hi - am looking for some technical Sage help please.

My client sets up a new invoice (customers/new invoice) and when the amount comes into the bank posts I have marked as paid in full (Bank/Customer/a/c).  - my understanding is that this then bank should be debited and debtors credited)

However, the payments don't appear to be showing in the bank account or show as paid on the customer record. 

It's not showing as outstanding on any report and when I look at the outstanding customer invoices (bank/customer/a/c) it's not there either.

Any thoughts would be most welcome - am trying to do a bank rec and this is sort of scuppering it!

Thanks in advance.

Lou 

• 
  Quote
  

• # 82099
• Fri 20 Apr 2012 08:17 AM

Hi,


I would go into maintenance and corrections and check your posting, as it sounds like you may have allocated the payment to someone else, as it would appear on the customer record as a receipt.


When you reconcile the bank, make sure that the statement date is after the date the payment was made, otherwise it will not show on the bank account either.


I hope this helps in some way.

Kind regards


Rosemary        

• 
  Quote
  

• # 82107
• Fri 20 Apr 2012 10:13 AM

This may sound daft, but have you checked which bank account you had highlighted when you entered the customer receipt.  It would not be the first time I have accidentally done a customer receipt to petty cash by mistake.

When you entered the customer receipt did you click down each individual invoice for paid in full - not discount.  Again that can cause problems.

If all else fails do as suggested and do a search in 'financials'  or 'corrections' for that amount and see where it has went 

• Pamela Dillon FMAAT MICB

• 
  Quote
  

• # 82118
• Fri 20 Apr 2012 02:42 PM

Hi - thanks for your guidance.

Found the transactions eventually - I had posted multiple payments together and so these were showing in the bank as one transaction.  Will need to post them all individually from now on then.

Cheers.

Lou 

• 
  Quote
  

• # 82135
• Fri 20 Apr 2012 08:23 PM

LouPsaid:

“Hi - thanks for your guidance.

Found the transactions eventually - I had posted multiple payments together and so these were showing in the bank as one transaction.  Will need to post them all individually from now on then.

Cheers.

Lou ”

• 
  Quote
  

• # 82150
• Sat 21 Apr 2012 12:26 PM

Hi there


In Sage you can UNgroup the transactions in the bank by going to [settings]  and choosing [bank defaults]

In the bank defaults window you can UN-tick [group bank transactions] and this will list all transactions seperately in the bank activity screen and reports. 

There is also another setting here called [group items in bank rec] and this one should be ticked if you pay more than one cheque into the bank on paying in slips because this will group the items, with the same ref. and date, into a single amount in the bank reconciliation screen only, reflecting the totals which will show on your bank statement against the paying in slip number.   


I hope this helps

Caz    

• 
  Quote
  

• # 82177
• Sun 22 Apr 2012 09:44 AM

Thanks all for your help.  Managed to get it all reconciled eventually - main problem was that batches of receipts pif covered dates past the statement date so all the transactions weren't included anyway.  Good learning experience and thanks for your advice - I think ungrouping the transactions should help in future, as will reconciling more than once a quarter (although to be fair I only started working for client in March).  

Enjoy the rest of the weekend all.

Lou 

• 
  Quote