Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am new in quickbooks, doing quarterly GST return in excel and totalling all necessary amount in excel instead of entering one by one in quickbooks, just wondering if there is a way I can enter the total amounts that I have and enter them in quickbooks to get the GST return amount for CRA payments to make it more acurate and generating some reports like income statements.
Thank
Hi Parviz,
QuickBooks Desktop offers an easy to navigate platform which simplifies the way you handle your accounting for your business. It's great to have you join the QuickBooks family! I'll be glad to give you a hand so you can adjust your GST amounts successfully.
The good news is that there are two ways to import your info into QuickBooks Desktop; Standard import and the Advanced import. Based on what you've described, if you'd like to take the route of importing your totals as an Excel file, follow the steps below:
Standard Import:
QuickBooks opens a formatted Excel spreadsheet where you can enter your information. When you save and close the file, you can review results and view your data in QuickBooks. To import Customers, Suppliers, and Products you sell which include your totals:
Note: If you need to import additional customer, supplier or item data from excel using this option, you can always go back to this window.
To import Chart of Accounts
Note: Before importing, we recommend that you create a backup of your company file.
Mapping your accounts tell QuickBooks how to import the data from your Excel sheet. The column headings in QuickBooks may be different from your Excel, so you’d need to match them.
I encourage you to check out this helpful article here to learn more about the Advanced import. If you just want to adjust the taxes, I recommend checking out this informative resource which shows you how: Process sales tax adjustment. In case you get stuck, don't hesitate to reach back to me in the comments below. I'm here to help you get on track so you can manage your business with peace of mind.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here