Bulk Import Accounting Details into Other Income via .CSV

If you have multiple Other Income entries to add, you can import a .CSV file to add them in bulk. To make sure your file has all of the columns you need, download the template attached to the bottom of this article.

 

Note: Unlike importing into the Inventory>FBA & Merchant pages or other areas of Accounting, importing into Other Income is an ADD ONLY capability.  It will not update data for existing income entries.

For example, if you export your Other Income, make changes, and import it back in, you will end up with duplicate entries for everything.

 

When you import into Other Income, your .CSV file should contain 5 columns which will correspond to:

  • Name
    • 50 character limit
  • Category
  • Amount
  • Date
  • Description

 

To begin, navigate to Accouting>Other Income and click the Import button.

Screen_Shot_2021-11-02_at_8.59.05_AM.png

 

You will see a warning letting you know that importing into Other Income is an ADD ONLY capability. Click OK to proceed.

Screen_Shot_2021-11-03_at_12.46.54_PM.png

 

Select the .CSV file from your computer that contains the income data you would like to import and click Next.

Screen_Shot_2021-11-03_at_12.52.00_PM.png

 

On the next screen, match the fields in Stratify to the columns in your file and click Next.

Screen_Shot_2021-11-03_at_12.56.12_PM.png

 

That’s it! You should now receive an Import Success message. Click OK to dismiss it.

Screen_Shot_2021-11-02_at_9.02.35_AM.png

 

Depending on the size of the file, it can take up to 20 minutes for the import items to appear.

 

Is this article helpful?
0 0 0