Solved

Financial Rounding by 000's query

Posted on 2010-11-10
3
814 Views
Last Modified: 2012-05-10
Hi,

I am assisting a client in production of Balance Sheets and P&L's etc.
There are a lot of spreadsheets involved here!

(I am more on the technical end of the data with a good understanding of accounts).

All the figures in the very final accounts that we produce will all be rounded to the nearest thousand.

So, how can we make the accounts balance when we are rounding off in such a big way??

What is the trick here?


0
Comment
Question by:Patrick O'Dea
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
JayConverse earned 500 total points
ID: 34107856
You don't, this is a display issue.  The underlying values are always the real numbers, you just display them divided by 1,000.
0
 

Assisted Solution

by:Patrick O'Dea
Patrick O'Dea earned 0 total points
ID: 34109698
Thanks JayConverse,

 However, see the simple sum below where 100+100+100=301.
Will this not cause a problem?

100,300   displays as 100
100,400   displays as 100
100,400   displays as 100
----------                      -----
301,100                      301
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 34265222
ok
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
creating a linked server on a 64-bit SQL 2008 to the 32-MAS ODBC driver? 10 2,186
Purchase Order System 4 240
imcfrundll.exe error comes from  what? 7 5,642
Where does Sage 50 Store its data 1 145
A frequent question here in the MAS90 Zone is, How do you get data out of MAS90 for analysis, reporting or using the data on your web pages?   This is an introductory level tutorial to getting data out of MAS90 using ODBC. Data can be accessed by…
Hi, I've just fixed a problem with Sage 50 Accounts 2010 crashing when creating a new Company.  I've spent nearly 4 hours on it including three calls to the Sage helpdesk (they didn't work it out in the end - I did!) ... so I thought I'd share th…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question