Import Budgets from Google Sheets
Design Template
Select Object, Operation, Start Cell and Rows mode
Mapping fields
Schedule Automatic Refresh
Upload in One Click
Modify Template
YouTube Videos
In order to upload data in QuickBooks, you need to be logged in into current QuickBooks account. Upload functionality is built on top of QuickBooks Online API functionality and utilize the structures that QuickBooks API supports.
This is one time process. The easiest way to map your data to QuickBooks object fields is to
1. Go to Extensions -> G-Accon for QuickBooks -> Get Accounting Data/Reports 2. Select Get Accounting Data
3. Select Budget object (table) and all attributes which you would like to upload. This gives you the structure that can be easily mapped and post into QBO file.
In our example, we are retrieving Budgets from one of the QuickBooks organizations. Here is the result of the execution.
Let’s create a New Budget in Google spreadsheet and upload it into QuickBooks. We have entered a new budget with name, type, status, and other attributes. Next step is to create the Upload Template:
1. Select Extensions ->
2. G-Accon for QuickBooks ->
3. Upload Accounting Data to QuickBooks ‘Company Name’.
You will see the Upload Accounting Data to QuickBooks ‘Company Name’ screen where you can specify what are you planning to change in Row Selection Mode, what object you are working on, what operation you need, what the start cell is and, where your result will be displayed in your Google Sheets.
Row Selection Mode gives you the ability to make the following selections (Notice: You do not need to select All Data area):
You can work on ALL Rows
Only New Rows
Currently Selected Rows
You can also specify Data Range and in this case you need to select Rows in the Specified Data Range
Or you can specify the row number Specified Row Number.
Your next step is to select the QuickBooks table (object) where you want to upload your data. Select the Accounts table and choose the operation from the Select Operation drop down box. G-Accon for QuickBooks supports Insert, Update and Delete operations. Accounts support Insert and Update operations.
The Address of the First Table Header Cell is the identifier of the top left corner of the DataSet and needs to be set up in case the data is not starting from A1, for example, in our case our template starts in A11.
The Result Column field is used to set the position of upload results.
Where Id is object id, Success will be true in case operation was fulfilled successfully, Created will be true in case insert was successfully, Error displays a error in case error happens and Timestamp is the time when operation was performed.
Option 2, Map table column headers and object fields, allow to you to map fields from your template to QuickBooks fields. Fields in QuickBooks table display the list of available QuickBooks fields that can be entered or updated. QuickBooks object fields CANNOT be changed. The goal is to map DataSet headers to the QuickBooks object fields. G-Accon provides field data types and discrete values. Column mapping contains the headers of your DataSet.
As our unique feature we also support custom field mappings. There are no restrictions on how your input DataSet headers are named. If any mandatory fields during the upload process are missed, you would be notified with the error message. For your convenience, we provide data types and values in case QuickBooks object field has fixed values such as “tax type”, “type”, “status”, etc. Please note that majority of fixed values have the internal QuickBooks format and they are different from QuickBooks user interface values.
You have the ability to DRAG a field from Fields in QuickBooks table above and DROP on the column you want to map it to.
To schedule the auto upload, you can create a workflow thru the option Create Workflow and schedule auto upload and notification processes. Automatic workflow allows users to create different workflows, include specific templates, set up the different schedules for different workflows, notify the customers, clients, and the team members using different automatic notifications within the same spreadsheet.
See the Create Workflow for further information.
This is the updated Budget from the google spreadsheet and the corresponding Budget screen in QuickBooks.
G-Accon offers the amazing ability to upload your financial data in ONE click. You just need to:
To modify your report:
Select the template, make the necessary changes to it and Update the template or Update and Execute the new query.
You can view the YouTube video on how to create the template and upload data from google spreadsheet to Xero or QuickBooks accounts: Upload Journal Entries
