On Center Home | MyOnCenter Portal | REQUEST A DEMO | CONTACT | SALES: 1-866-627-6246
 
 
Advanced
How to Use Search Effectively
Login


Tools Add
Table of Contents

QB 4.97 - 09.02.06 Intuit® QuickBooks® Accounting Export

Reference Number: AA-01735 Views: 897 Created: 11/28/2017 06:47 am Last Updated: 04/18/2018 03:05 pm 100 Rating/ 1 Voters

Our developers worked with Intuit to determine what they need to use our export.

Note
On Center Software does not provide assistance with importing the Budget File into your Accounting package. Accounting packages are very complex and the vendor of your particular Accounting package is best equipped to support it.

To export the budget to QuickBooks Accounting software,

Click the Exports button on the Bid toolbar

Select Job Budget File

Click the Options Button next to "Job Budget File - the Modify Options for Job Budget File dialog box opens

From the Export Format drop down, select "Intuit QuickBooks" (exports to an XLS file)

Select the options and filename/location where the export file is to be saved

Click the OK button to return to the Bid Exports screen

Click the Export button (your file is not generated until you click the Export button)

The Budget File export allows you to create a Budget in QuickBooks, based on the final Bid information from Quick Bid. For assistance importing a budget file into QuickBooks, please consult your QuickBooks User Guide or Intuit’s support.

Export Column Definition

Note
Only one row per Account Code or Cost Code is included in the Export. This row will summarize the total amount per code.

Column # Column Title/Label Column Value
1 !BUD BUD
2 ACCNT If Use Account Codes is not checked: <Cost Code> If Use Account Codes is checked: <Account Code> If Cost Code does not have an assigned Account Code: <Cost Code>
3 AMOUNT If Distribute Tax is not checked: <Labor Net Amount> / <Material Net Amount> / <Equipment Net Amount> / <Other Net Amount> / <Subcontractors Net Amount> If Distribute Tax is checked: <Net Amount + Tax> If Distribute Burden is checked: <Net Amount + Burden>
4 CUSTOMER <Bid Name>
5 PERIOD MONTH
6 STARTDATE <Date selected in Options Dialog>

Export Example


Discussion
  • There is no feedback for this article.
Info kBase Article Feedback

If you need Technical Support or want to submit a Feature Request, click one of the buttons below, do not use this form.

 
request support Request Support submit feature request Feature Request

 

How Does This Article Not Measure Up?

Your full name: Your Email: Your feedback on this article:

 

Something Wrong with this Article? Let us Know! Copyright 2018 - On Center Software, Inc. All Rights Reserved.
Be sure to rate this article 5 stars if you found it helpful!.