DocuSend QuickBooks App Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > QuickBooks Enterprise Edition Forum

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 05-06-2017, 03:07 AM
Abid Saeed Abid Saeed is offline
Registered User
 
Join Date: Apr 2014
Posts: 57
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
Reply With Quote
  #2  
Old 05-06-2017, 04:15 AM
Rustler Rustler is offline
Registered User
 
Join Date: Feb 2008
Location: Texas - The Republic
Posts: 2,276
As far as I know you will have to do it manually
Reply With Quote
  #3  
Old 05-06-2017, 07:50 AM
Lorin Browning Lorin Browning is offline
Registered User
 
Join Date: Apr 2004
Location: Landrum SC
Posts: 565
Would the Show all numbers without cents option work?
__________________
Lorin Browning, Ph. D.
Fellow -- National Tax Practice Institute
lorin@lorinbrowning.com
Reply With Quote
  #4  
Old 05-07-2017, 04:00 AM
Rustler Rustler is offline
Registered User
 
Join Date: Feb 2008
Location: Texas - The Republic
Posts: 2,276
Quote:
Originally Posted by Lorin Browning View Post
Would the Show all numbers without cents option work?
I have not tried it, but I think that option is for reporting only.
Reply With Quote
  #5  
Old 05-08-2017, 08:32 PM
Lorin Browning Lorin Browning is offline
Registered User
 
Join Date: Apr 2004
Location: Landrum SC
Posts: 565
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.
__________________
Lorin Browning, Ph. D.
Fellow -- National Tax Practice Institute
lorin@lorinbrowning.com
Reply With Quote
  #6  
Old 05-09-2017, 04:37 AM
Rustler Rustler is offline
Registered User
 
Join Date: Feb 2008
Location: Texas - The Republic
Posts: 2,276
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
Reply With Quote
  #7  
Old 05-27-2017, 01:25 AM
Abid Saeed Abid Saeed is offline
Registered User
 
Join Date: Apr 2014
Posts: 57
What meant by "clr" in Quickbooks Ledger

Hi,
What meant by CLR in ledger, and for what and how it is be used?
Reply With Quote
  #8  
Old 06-06-2017, 03:47 PM
John S John S is offline
Registered User
 
Join Date: Jan 2015
Location: Utah, USA
Posts: 28
Quote:
Originally Posted by Abid Saeed View Post
Hi,
What meant by CLR in ledger, and for what and how it is be used?
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.
Reply With Quote
  #9  
Old 07-13-2017, 12:48 AM
Abid Saeed Abid Saeed is offline
Registered User
 
Join Date: Apr 2014
Posts: 57
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.
Reply With Quote
  #10  
Old 07-13-2017, 11:28 AM
John S John S is offline
Registered User
 
Join Date: Jan 2015
Location: Utah, USA
Posts: 28
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.
Reply With Quote
Reply

Bookmarks
Bookmark and Share
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is On

Forum Jump


All times are GMT -5. The time now is 07:59 AM.


 

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