How do I move to a new financial year in Sage Query?
I am trying to do a query in excel, prior to the year end in July07 the query worked fine every month.
Now, when the query returns nominal balances it is giving me the balance from 12 months ago. For example, if I run a query on nominal balances today it isn't returning the balances showing in sage for November 2007, it is giving me November 2006 balances.
The balance for mth1 is giving me August06 instead of August07 and so on.
Do you have any suggestions as to why this is happening?
- Accounting for cash put into Ltd 47 1
- LTD home office - would HMRC seek to disallow 1,261 8
- RTI and corrections to payroll 1,236 13
- Accountancy practices - are you closed over Christmas or do you let your staff take it off? 976 29
- You know its over 378 4
- HMRC BACK AND FORTH FIGHT ON BTL PROPERTY ALLOWANCES 508 9
- How do you find shareholders of a Cyprus Company ? 247 13
- Valuing my fast-growing internet business for transfer of goodwill on incorporation 198 2
- HMRC won't let me set up online DD for PAYE 182 2
- What is the amount of dividends received as a shareholder that requires registration for self assessment? 290 3
- Cocaine anyone? 532 8
- Late Registration for VAT 500 13
- EIS/SEIS 158 1
- Amortisation of Goodwill 285 1
- TaxCalc Accounts production 435 5
- Depression - HMRC penalties case won because of this illness. 434 12
- Solicitors now, Accountants next 735 10
- How come if you claim benefits you are not entitled to you either have to pay a 50% penalty or are sent to court and either fined or sent to prison (sometimes suspended) and end up with a criminal record. 569 10
- ACCA - still making me laugh 602 4
- Personal pension 408 9
- Hive up 497
- Accounting referance change & deficient accounts. 465
- corporate hierarchy 447
- Advice - 278
- Anyone had HMRC refusing to act on EPS database glitch? 230
- WWOOFers 224
- Co. limited by Guarantee now closed 212
- Art Gallery - Splitting a property between business and personal use 208
- Tax liabilities in USA for warehoused products 187
- Mutual Trading - Exempt CT Income - Do I need clearance? 181