Forum

• # 87297
• Tue 18 Dec 2012 10:56 AM

Hi

I have noticed that some payments (ocassionally - recepts) have combined together eg: three seperate expenses.  Is there a way of correcting this as it makes bank rec slightly confusing.

Thank you in advance
Jo'Anne 

• Jo'Anne
• 
  Quote
  

• # 87298
• Tue 18 Dec 2012 11:56 AM

Hi,

This is due to the program being setup to do this so that if you use the same date and reference number in bank receipts/payments it will group the total together for the bank rec.
This is very useful for bank rec if you have received many cheque payments from customers and they are all banked on the same day and you would use the pay-in number as the reference.
This facility can be removed from the program settings but I suggest you leave it and just make sure you put a different reference for each receipt/payment and then they will show up separately.
Regards,
Marilyn   

• A clever person solves a problem.

  A wise person avoids it.

  Albert Enstein

• 
  Quote
  

• # 87302
• Tue 18 Dec 2012 03:30 PM

>
> Thank you - this has made it clearer ...
>
>

• Jo'Anne
• 
  Quote
  

• # 87612
• Thu 10 Jan 2013 02:14 PM

MM Bookkeepingsaid:

“Hi,

This is due to the program being setup to do this so that if you use the same date and reference number in bank receipts/payments it will group the total together for the bank rec.
This is very useful for bank rec if you have received many cheque payments from customers and they are all banked on the same day and you would use the pay-in number as the reference.
This facility can be removed from the program settings but I suggest you leave it and just make sure you put a different reference for each receipt/payment and then they will show up separately.
Regards,
Marilyn   ”

• Jo'Anne
• 
  Quote
  

• # 87613
• Thu 10 Jan 2013 02:35 PM

Sorry 
They seem to all be multiples of the same n/c code and dates but different details for each...
so if the date and n/c is the same does this mean I should still be able to reconcile them to the bank statement where I can see they total the amount showing up in my reports?

We are coming up to our year end - There is only me in the office doing everything (I have never done a year end before) our accountant wants me to get as much stuff reconciled as possible and find as many hic-cups so they don't have to spend too much time sifting through everything.
Does everything have to be reconciled before a year end can be run...?
 

• Jo'Anne
• 
  Quote
  

• # 87615
• Thu 10 Jan 2013 02:50 PM

Hi Jo Anne


Each payment is posted separately, however, if when posting the same reference number is used, the accounting program may add them together to show as one amount on the bank rec.  If you 'click' on the amount you may be able to see the breakdown of the payments.  This is not very helpful for payments as on the bank statement they will show as individual amounts.


Are the cheque numbers listed on the original posting as this will be shown on the bank statement?


If you are sure that they are the ones you have identified on the bank statement then you can match them.  


However, if this method is used for posting receipts and the same reference number is used (usually the paying in slip number) only one total will show on the bank rec and can be identified by the reference number as it will show on the bank statement and the amount will be the same.


    


        

• 
  Regards
  Jocelyn

• 
  Quote
  

• # 87618
• Thu 10 Jan 2013 03:22 PM

Hi Jocelyn,

Thank you for your response:

Are the cheque numbers listed on the original posting as this will be shown on the bank statement? 
The few cheques that we write have their number in the bank statements but i have to locate them as the dates in my reports are the date they were written out and not they date they show up in the bank statements.  (I have to catch hold of chq's being paid in from our customers to get hold of the chq number before it is taken to the bank.)

If you 'click' on the amount you may be able to see the breakdown of the payments.  This is not very helpful for payments as on the bank statement they will show as individual amounts.
Yes this is what happens - I use Sage 50 Accounting and can see in edit mode how many are included in a single transaction.

I think perhaps I should try to come up with a more logical method than the hotchpotch mehtod which has been handed down to me... its been quite a steep learning curve  

Kind regards
Jo'Anne 

• Jo'Anne
• 
  Quote
  

• # 87621
• Thu 10 Jan 2013 04:27 PM

Hi Jo Anne

Are the cheque numbers listed on the original posting as this will be shown on the bank statement? The few cheques that we write have their number in the bank statements but i have to locate them as the (1) dates in my reports are the date they were written out and not they date they show up in the bank statements.  (2)(I have to catch hold of chq's being paid in from our customers to get hold of the chq number before it is taken to the bank.)



(1)  The dates on the sage reports and the dates on the bank statements will be different.  When you post cheques you write you use the date they were written wereas the bank will use the date they were 'presented' to them.  That is why it helps to use the cheque number when you post them. You need to post them onto Sage when you write them and not wait until they appear on the bank statement.  This will mean that you know exactly what has gone thru the bank and what is still to be 'presented.'


(2) You don't need the cheque numbers of your customers cheques.  You need the paying in book slip number.  Put this in the reference on Sage when posting them, you can write more than one cheque per paying in slip. The reference number will show on the Sage report and on the bank statement.


'Computerised Book-Keeping' by Peter Marshall is an accredited textbook of the ICB and uses Sage 50.  You might find it useful.   


        



   

• 
  Regards
  Jocelyn

• 
  Quote
  

• # 87624
• Thu 10 Jan 2013 04:41 PM

Thank you Jocelyn

you have been very helpful

Regards 

• Jo'Anne
• 
  Quote