Financial Rounding by 000's query

Posted on 2010-11-10
Medium Priority
Last Modified: 2012-05-10

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?

Question by:Patrick O'Dea
  • 2
LVL 12

Accepted Solution

JayConverse earned 2000 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.

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

Author Closing Comment

by:Patrick O'Dea
ID: 34265222

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
When you read payment gateway for E-commerce business, the first name that comes to your mind is PayPal. It is the most widely used payment gateway in the majority of the E-commerce platforms all over the world.
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…

607 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