Skip to main content
P
Parviz11
November 16, 2020
Question

Entering total amount from Excel to quickbooks

  • November 16, 2020
  • 1 reply
  • 0 views

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 

1 reply

J
JamesTao
November 16, 2020

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:

  1. Go to the File menu, select Utilities then Import and then Excel Files.
  2. If you get the Add/Edit Multiple List Entries window, click No.
  3. Follow the wizard in importing files.
    1. Select the type of data.
    2. QuickBooks opens a formatted excel spreadsheet. Once you have entered your information, saved the file and closed it, you will be given the option to Add My Data Now.
    3. Review results and view Data in QuickBooks.
    4. Select Close when done.

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.

  1. Go to the Lists menu, then select Chart of Accounts.
  2. Select the Account drop-down at the bottom, then choose Import from Excel.
  3. Select Browse to select the Excel file you want to import.
  4. Select the file, then select Open.
  5. Select the Excel Sheet where the data you want to import is on.
  6. Map your accounts.

    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.

    1. Type in a mapping name.
    2. Select Account as Import type.
    3. Match the information under QuickBooks with the column headings in your Excel sheet.
    4. Select Save.
  7. Select Import. If it's your first time to import, select Yes to confirm the process.

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. ​​​​​​​

Terms & ConditionsAccessibility statement