Import Transactions to QuickBooks Online: Create, Save and Use Your Mappings in Business Importer


Import Transactions to QuickBooks Online, using . Read how to create, save and use your mappings during imports to QuickBooks Online in .

Create, save and use your mappings during Excel import to QuickBooks Online in Business Importer

To save your time on bookkeeping work in QuickBooks Online, use the Mapping Saving feature in Business Importer.

To create and save your mapping in Business Importer, follow several easy steps:

      1. Sign in to Business Importer. Prepare your Excel file you’re going to import into QuickBooks Online.
      2. Go to the Import tab, and upload your file.
      3. Select sheet and entity, and company you’re going to import your Excel with transactions into.
      4. Connect your labels to QuickBooks Online labels.
        import transactions to quickbooks online using business importer
      5. Business Importer will save your mapping automatically (giving name by date, time and entity). If you want to give a name to your new mapping, fill in a name for your new mapping (for example, Invoices) in the appropriate window.
        save mapping
        Press on the Next button.
      6. Preview your mapping. Make sure all labels are connected in a correct way. Press on the Next button.
      7. Your import is running. Your mapping is saved.

To use your saved mapping, follow simple steps:

      1. Follow Steps 1,2,3.
      2. In the Create New Mapping drop-down menu select the saved mapping (Invoices). All of your columns will be automatically mapped according to the saved mapping settings.import transactions to quickbooks online: saved mapping
      3. Run your import.


      • Apply Saved Mappings to the same entity/transaction, and the Excel file containing the same columns names.
      • You can Rename, Copy and Delete mappings.

import transactions to quickbooks online: mapping



Remember, that you can address us with any question you might have. We will be happy to assist.

Leave a message, email or call us at (302) 261-3644.



This entry has 0 replies

Comments open

Leave a reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>