QuickBooks Forums

QuickBooks Forums (http://forums.quickbooksusers.com/index.php)
-   QuickBooks Enterprise Edition Forum (http://forums.quickbooksusers.com/forumdisplay.php?f=23)
-   -   How to round off numbers (http://forums.quickbooksusers.com/showthread.php?t=67384)

Abid Saeed 05-06-2017 04:07 AM

How to round off numbers
 
Hi,
i am using enterprises solution of quickbooks.
How can i round off numbers in sales invoice and ledger.
Say 120,000.11 round off to 120,000.
If the number after decimal is below 5 it should round the number to down, and number equal or greater than 5 should round the number up.


Regards

Rustler 05-06-2017 05:15 AM

As far as I know you will have to do it manually

Lorin Browning 05-06-2017 08:50 AM

Would the [B]Show all numbers without cents [/B] option work?

Rustler 05-07-2017 05:00 AM

[QUOTE=Lorin Browning;175619]Would the [B]Show all numbers without cents [/B] option work?[/QUOTE]

I have not tried it, but I think that option is for reporting only.

Lorin Browning 05-08-2017 09:32 PM

You are probably right. I checked only the general ledger report and not other reports.

But I wonder if one would actually want to do this rounding if sales tax is involved.

Rustler 05-09-2017 05:37 AM

Here in TX, when we report when doing sales tax to the state, we round off to whole dollars, I wonder if that is part of the issue.

No way to know unless the OP explains where and why I guess

Abid Saeed 05-27-2017 02:25 AM

What meant by "clr" in Quickbooks Ledger
 
Hi,
What meant by CLR in ledger, and for what and how it is be used?

John S 06-06-2017 04:47 PM

[QUOTE=Abid Saeed;175808]Hi,
What meant by CLR in ledger, and for what and how it is be used?[/QUOTE]

In the General Ledger, the CLR column is used to show which transactions (primarily checks or deposits) have cleared the bank or have been reconciled.

Abid Saeed 07-13-2017 01:48 AM

Sir,
You mean that 'Clear' option in quickbooks connected with bank online feature of quickbooks?
We can not do it manually, or what i understand it that this feature did not works if you are not using online bank feature quickbooks.

John S 07-13-2017 12:28 PM

The "Cleared" column is for when you reconcile your bank account. I am not sure how it works with QB Online and directly downloading banking information, but when you are in the reconciliation process and you mark an item as cleared, a * shows in the column until the reconciliation is either canceled or completed. Once the reconciliation has been completed, the * is replaced by a check mark.


All times are GMT -5. The time now is 05:27 PM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.