Monthly Management accounts
Blonde Accountant
Registered Posts: 86 Regular contributor ⭐
Hello,
A company that I do the book-keeping for uses Sage 50 Accounts Professional. We want to start producing monthly management accounts from April 13. The year end was March 13, but this has not been completed yet and is not likely to be for some months yet. This may be a stupid question, but is it possible to produce monthly management accounts on Sage?
Thanks for looking
Nicola
A company that I do the book-keeping for uses Sage 50 Accounts Professional. We want to start producing monthly management accounts from April 13. The year end was March 13, but this has not been completed yet and is not likely to be for some months yet. This may be a stupid question, but is it possible to produce monthly management accounts on Sage?
Thanks for looking
Nicola
0
Comments
-
I've always found it easier to take the information out and work on it in Excel0
-
I agree, the best option is to download the data into Excel and produce your management accounts from these.
You can produce the accounts through sage but they don't come out to well, In excel you can automate the production of KPI reports and other management info.0 -
Hi
You will want to post all your accruals and prepayments in sage, get all your data on there as you want it
Then export to data to excel, and analyse it from there
Working with a lot of data in excel runs the risk of creating and error and spending hours trying to find it
Craig0 -
Blonde Accountant wrote: »Hello,
A company that I do the book-keeping for uses Sage 50 Accounts Professional. We want to start producing monthly management accounts from April 13. The year end was March 13, but this has not been completed yet and is not likely to be for some months yet. This may be a stupid question, but is it possible to produce monthly management accounts on Sage?
Thanks for looking
Nicola
If you go to financials, then reports, then management reports, you'll find monthly management accounts reports.0 -
Hi
You will want to post all your accruals and prepayments in sage, get all your data on there as you want it
Craig
I always do it this way, post accruals/prepayments in Sage each month.
Some people only put these monthly accruals/prepayments in Excel (adj column). And then post the final y/e figures in Sage. Which kind of makes sense, keeps the nominals cleaner!0 -
Thanks Reader, I shall have a look at that, but also thanks every one else, I might try the excel option.
Again thanks loads for all of the help and suggestions.
Nicola:001_smile:0 -
You need to do 'Transactional' reports because the year end has not yet been run.
When you go into the Financials module, where the TB, P&L and Bal Sheet icons are, go into Reports and there should be separate links to the 3 reports and within those menu's should be Transactional TB, trans PL, trans BS - these will allow you to put in the date range - ie 01/04/13 to 30/4/13 until such time as you run the year end and can then use the icons again.
If you want a different layout for the P&L and BS you can do this - but if your new(ish) to Sage its probably worth seeing if you have sage cover and getting them to run through it with you - or putting it onto Excel Spreadsheets as suggested previously.0 -
You need to do 'Transactional' reports because the year end has not yet been run.
When you go into the Financials module, where the TB, P&L and Bal Sheet icons are, go into Reports and there should be separate links to the 3 reports and within those menu's should be Transactional TB, trans PL, trans BS - these will allow you to put in the date range - ie 01/04/13 to 30/4/13 until such time as you run the year end and can then use the icons again.
I never knew about the transactional reports so thanks a lot for posting. I had always just used the 'Future' setting on the standard P&L, which isn't great if you don't want all the after YE transactions! It seems you can run the transactional report for periods in previous years too, which is good for comparisons.0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 323 NEW! Qualifications 2022
- 165 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 88 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership