Solved

Financial Rounding by 000's query

Posted on 2010-11-10
3
824 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

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

If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…
As an accountant it is essential that I am able to provide accurate and timely information to management and staff.  One of the challenges that I have faced is the need to report on a time period, whether it be a month, quarter, or year, and wanting…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

691 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