Excel zone

Sage Line 50 - Tips and Queries #2

SAGE Line 50 - new company set up
The Company I have started to work for is running SAGE Line 50 V8 with multi companies and I want to set up a new company but copying supplier records and nominal structure from one of the others. In the new company wizard it says you can create a new company and at the same time convert data from one of your earlier companies into it, but either I'm going daft or blind but I fail to see where this option is offered

Expenses on Sage - set up debtors?
Whenever I need to pay staff expenses I put it through Sage via 'Bank' & 'payment'. A friend who also pays expenses & uses Sage says I should have set up each staff member as a supplier & pay via 'bank' & 'supplier'.

Bookkeeping & Sage Opening Balances INSTANT
I provide administrative assistance to a small local ltd company. The current bookkeeping system is maintained via spreadsheets. ie Sales Day book, Purchases day, bank rec. This is done by the director. I do the filing of receipts etc. Accountant has now suggested company should get a computer package and the company bought Sage Instant Accounts. .... I would like to ask for some assistance in entering the opening balances as the accountant says we have all the relevant balances in the year end accounts and this is an easy task - unfortunately with no further help.

Sage Line 50 Dividends
Trying to get to grips with Line 50 from a non accountancy background. How do you post dividends and dividend payments on Line 50? Paul Duffy

Sage Line 50 & Suppliers Who Factor
We have just installed Line 50 Financial Controller, and a couple of our suppliers factor their invoices. How can I set up the supplier so that orders raised throught the POP module are addressed to the supplier, but remittance advices for payments are addressed to the factoring company?

Sage - Sole trader to Ltd Co?
135164 Happy New Year!! Probably an obvious answer - but not to me!! What is the best way to transfer sole trader accounts (non VAT registered) to a Limited Co (VAT registered) within Sage? Can I continue to use the company crested, just changing the year end date and re-pricing to include VAT, or will I need to set up a new company and transfer balances? Many thanks for helping! Anita Vine

Splitting a purchase invoice in Sage Line 50
133887 Is it possible to split a purchase invoice between nominals in Sage Line 50 version 9? Nicholas Robinson

Sage old invoices
I use Sage Line 50 and after running the year end at 31 March some unexpected late invoices arrived in April and May. I was off at the time so a colleage was covering, she paid the suppliers and posted the cheques but hasnt posted the invoices as they are March 04 so relate to the last tax yr. I have several credit balances now sat on my accounts due to the chq payments, how I do get around entering these March invoices? lynne willerton

SAGE Brought forward balances
130396 Sage nominal code 6300 has a brought forward balance on 01 June 2004. The year end is 31 May 2004 and the year end routine has been run. Why did the amount in code 6300 not get transfered to Reserves when the year end took place? A year to date Balance Sheet at 31 August 2004 shows a "Previous year adj" for the amount in code 6300. What has gone wrong? How do I correct this? Any help would be appreciated. Gerald Lunn

Sage line 50 - applying credit notes against invoices
128199 Can you apply credit notes against specific invoices in sage ?? Any help would be appreciated. John Davies

Where do I record my steps costs in Sage?
128135 I provide web hosting to small businesses and in doing so I buy services in bulk and resell them in smaller packages. I'm trying to decide where to put the service costs in my Sage Instant Accounts. Options seem to be 5000 "materials purchased" or 6002 "sub-contractors". Any advice? Steve Smith

Sage Opening Balances
128080 Recently I've converted a client's accounts from a manual system to Sage Accounting. Entering the opening balances was straightforward until it came to the bank balance. There are some unpresented cheques dated from the last financial year. Sage recommends to enter these as Bank Payments and debit the suspense account. Now I've entered the full opening trial balance but I still have a debit balance on the suspense account for these cheques. Does anyone know how to clear it?

Sage Line 50- payment selection editing
126376 Sage allows you to pay suppliers one at a time or by batch - which selects every outstanding balance on the ledger. In my new company we process about 300 supplier payments by Bacs each month. I had hoped to replace our existing software with Line 50 and use the electronic banking facility - but I am dismayed to discover that this still only allows payment selection in the same way.
What I want to do is get a list of due payments which can then be revised - transactions added or removed. It appears that this is still not possible- according to Sage sales and technical support. I find it difficult to believe that no-one at Sage has recognised this as a serious limitation and given it priority for the next release- it defeats the object of automated payments. Does anyone have a way round this? Owen Bishop

Sage processing
125410 I have just started using Version 10 of Sage Line 50 and cannot find a nominal code on the default chart of accounts to let me record bank interest received. Can someone please let me know how this should be recorded and if I need to set up a new nominal code then please let me know which category to record this under. Sage helpdesk were no help. William Thomson

Bouncing Direct Debits in SAGE Line 50
122231 I am new to SAGE and a business that calls off a lot of direct debits. If one bounces, how do I unwind SAGE to show the original invoice outstanding whilst still reflecting the bank statement (cash in and out) in the accounts. At the moment -we delete the original transaction -that leaves the original invoice unpaid -but does not reflect the bank account in SAGE.

Sage Line 50
117610 When running the report 'Time taken to pay sales invoices' this shows all clients paying before the invoice is actually raised. Example ' invoice raised in July 2003, receipt received August 2003, but according to the above report the receipt has an allocation date of Feb 2003.
When going into file maintenance then corrections for an SR entry then edit then split this shows the wrong allocation date. I have a receipt input via Bank Sales Receipts with a date received of 11th August 2003. However when going into file maintenance I have an allocation date of 19th Feb 2003. This makes the above report useless. Anybody come across this before and how do I put it right?

Clients accounts are on Sage
116142 After having spent sufficient on Iris which is really efficient, do i have to have Sage also in order to just read the client's data. I do not actually need to use it as a bookkeeping package. The trouble is as you load more companies on it, the price goes up each time and as far as i am aware, the client has to have the sanme version also so there appears to be extra cost in upgrading.
Is there no way around this. Is the only way around this to print off all the Nominal/TB etc in order to transfer the accounts onto Iris. Thanks for any comments, still learning the IT ropes!

Reporting cash flow information in Sage Line 50
111004 I have clients who are happily using Sage Line 50. In both cases they gave cash flow projections to their banks, and these banks are looking at the profit and loss accounts produced in Sage and trying to tie them up to the projections. Ideally they want to have a report just like a profit and loss account, that will show net cash inflow or outflow using the existing chart of accounts

Help on Sage Line 50
106405 I am at the beginning of the financial year. In one of the Bank Accounts I've got few cheques written last financial year and cleared in this year. How do I treat them? They have to be on my system for Bank reconciliation.
Shall I post them: Bank, Payments, Different Accounts or shall I bring these payments as opening creditors? Many thanks in advance. Ioana

Nominal Coding-Sage Line 50
We are a small company who provide care for people with learning disabilities. I am thinking of changing the sections for nominal coding. We have to invoice the housing associations on behalf of the residents for things like cleaning allowances, telephone line rentals etc. Once we are paid we in turn reimburse the residents with any amounts received.
1. Would it be a good idea to use 5000 codes for both the invoice raised and the reimbursements made, therefore cancelling all costs.
2. I do not understand what the 6000 codes are for???
3. In your experience if breaking down costs in to departments (individual houses) would you use one code e.g. 7502 for telephone and just put the department code in, or would you make new codes for each department e.g. 750201 for Department One 750202 Department Two etc. Helen Pearce