• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 840
  • Last Modified:

Financial Rounding by 000's query

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
Patrick O'Dea
Asked:
Patrick O'Dea
  • 2
2 Solutions
 
JayConverseCommented:
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
 
Patrick O'DeaAuthor Commented:
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
 
Patrick O'DeaAuthor Commented:
ok
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now