Exporting Sage Aged Debtors report to Excel
Running Sage line 50 Accountant version 13 (2007) I am trying to export a sage report (aged debtors summary) to excel to do more analysis. I've tried several methods none of which work precisely as I would wish.
Method 1: Select required report, Aged Debtors Analysis Summary. In drop down, select File, click generate report. and for save as type, select Excel .xls.
This creates an excel file which on first sight looks ok, BUT closer examination reveals that for some of the fields (Account and Name) where the value is longer, they occupy two cells which are merged.
(As an experiment, I tried changing the field width in the report designer - increasing field width made no difference, but reducing the field width solved the problem of merged cells, but the name is curtailed at less characters. I've also used the format painter to de-merge (un-merge?) the cells, but this is not ideal.)
Method 2: is as method 1, but chose Comma Separated Variable .csv as file type. This generates a blank .csv file (not only appears blank, but has 0 size.
I've tried various searches with Sage, and there is some interesting stuff on the report generator, but nothing I found addresses this specific problem.
- Builder Gifted Deposit and capital gains 493 19
- Husband and Wife Holiday letting profit split 48 2
- Tax on sale of shares 49 2
- Limited Company - Personal Bank Account 572 22
- Amazon - digital book sales 210 2
- late payroll registration 68 1
- *Urgent pls advise * filing dormant accounts to Companies House 452 18
- Paint Manufacturer Flat Rate Scheme 44 2
- Profit and Loss Account Adjustments 175 7
- Expenses paid by director (the owner) 247 4
- Breaking Up A Property Company 266 2
- Website development costs - tax and accounting treatment 228 3
- G'day IPA-IFA 523 8
- Declaration of Trust 571 20
- Inventory valuation of precious metals? 74 1
- Who can wind up a Promissory Trust? 95 2
- MAAT signing off ACCA PER? 334 2
- tax insider 335 4
- Auto-Enrolment 230 3
- Annual subs 188 2
- Skandia using wrong address 1,416
- Nil Rate Band Trust - index linked debt by way of charge over property 728
- Any views 662
- HMRC Employers Diary 494
- International interest certificate 410
- Stamp Duty on share for share exchange 370
- Sale of business 320
- NOVA 227
- IR35 & Managed Service Companies 226
- Advertising services? 221