The Book-keepers Forum (BKF)

Post Info TOPIC: Entering bank statements


Member

Status: Offline
Posts: 5
Date:
Entering bank statements
Permalink Closed


Hi,

Recently i have undergone Sage line 50 accounts . I have joined a company and i  have a query like how to enter the bank statements  data.They have given  the  bank statements. In which format  can  i enter the  data. Pls help

__________________
suchi


Senior Member

Status: Offline
Posts: 200
Date:
Permalink Closed

Need a bit more explanation. Have any supplier and customer invoices been processed on the supplier and customer ledgers and have any payments made been entered eg from the cheque book, and from paying in book? Also any bank payments for drawings etc

You need to enter these details first and then reconciling the bank statement should be quite straightforward.

Please advise







__________________


Member

Status: Offline
Posts: 5
Date:
Permalink Closed

Hi Digits,

The bank statements includes transactions as salaries to staff,Directors Remuneration,Rent charges,Funds from Dpw,charities and bank interest,Phone charges,Electricity Charges,Public Liability Insurance,Workshop services and printing and posting charges and Drawings too.

I have entered these details into excel.Is it the right method as i am new to accounts field.

Thanks,
Regards

Suchi

__________________
suchi


Senior Member

Status: Offline
Posts: 200
Date:
Permalink Closed

If you wish to enter this data into sage then it sounds like mostly are bank payments. I presume that you have set up sage with the correct year end etc, company details.

If you look at the nominal ledger you will see a list of account numbers. You need to decide which account numbers these bank payments relate to.

eg Drawings usually Account no. 3000, Postage 7501 etc etc

Income usually Account 4000+

If you are new to sage I would suggest doing a course. Also you can look on sage help on the menu at the top of the screen.

Hope this helps!



__________________


Member

Status: Offline
Posts: 5
Date:
Permalink Closed

Hi Digits,

Thanks alot for your reply.

As the company is not VAT registered and the tax code is used was T9.Can you help me out for few nominal codes for these items.

Funds from DWP
charities
Business Software maintenance charges
complimentary expenses
Public Liability Insurance
Workshop Service
Seminar expenses
Internet Charges

Regards
Suchi




__________________
suchi


Senior Member

Status: Offline
Posts: 200
Date:
Permalink Closed

Suchi

Depending on what your chart of accounts are set up as but normally around these codes.

Internet Charges - Usually put in with Fax/telex etc You can amend the description - 7503

Seminar Expenses - Need more details, but hotel expenses is 7402

Public Liability Insurance - 8204

Business Software maintenance Services - 7701 is Office machine maintenance, so I would probably set up a new account around this number eg 7702

Charities - Is this money paid to charities eg donations, if so 8200

Funds from DWP - Can you give me more detals.

Complimentary expenses - Can you give me more details.

Workshop Service - Can you give me more details

Hope this helps



__________________


Member

Status: Offline
Posts: 5
Date:
Permalink Closed

Hi Digits,

Thanks alot for your reply.

Complimentary expenses are those which are borne by the company to client.
Worksshop services are those where in company provides training type of services to their customers.
But the company has only sales invoices.It is completely based on Service Invoices but not on product Invoices.Currently i have just created nominal codes.
suppose if the company doesnt have any purchases then how would you make a profit and loss and a balance sheet reports for those companies which have sageLine 50 accounts.
Please advice

Thanks& Regards,

Suchi







__________________
suchi


Senior Member

Status: Offline
Posts: 200
Date:
Permalink Closed

Not sure if I am correct but I would think Complimentary expenses you are describing is entertaining.

Anything like sales/services would usually be set up under the 4000 code.

Purchases would usually go under 5000, but you will still have some overheads eg Stationery/Insurance etc which would be deducted from your income on the profit & loss account.

With regardds to the profit & loss reports and balacne sheet you would check the reports under financials. You may need to check your chart of accounts beforehand.

Hope helps.






__________________


Member

Status: Offline
Posts: 5
Date:
Permalink Closed

Hi Digits,

Thanks for your reply.

Another query regarding the customer bank receipt. I have posted the customer invoices to sales ledger.Then paid the invoice infull by customers bank receipt.Do i need to do the remittance advice first.After finishing the above process now the customers balace is showing zero and all the customers balances are zero.What could be the next step then?As i wrote to youthat the company doesnt pay tax so i setted the tax code as T9.Please advice how can i get back my customers balances.By the way these all are service invoices.This company has only service invoices to enter.Can you prefer any links to go further.

Thanks a lot.

Regards,

Suchi

__________________
suchi
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About