CNA L&P - Import Transactions: How to and Troubleshooting

This article will highlight common problems users have with the Import feature in ConnectNow Accounting.  

The Process menu has options to import a budget or the following journal entries: payroll, deposit, and general journal.

 

.

 

Importing a budget 

To import a budget, you must use a file that you first exported through the software.

Where do I export the budget file(s)?

In the Process, Budget screen

   

Go into the correct Budget Year for your purpose and choose the Export button at the bottom of the screen.

see also the Budget FAQ article

 

What to do if your budget spreadsheet won't import

Make sure the file is in an ".xlsx" format

 

How do I know which budget year I'm importing (e.g. current, next year, or next year +1).

The system tags the file when it is exported so the software will know where to put the imported data. Note: you may not export the current year data and import it over the next year data.

 

.

Importing Payroll

Where do I find the payroll import template?

You can find the link to the template in the import window under Process, Import Payroll.

          

What format should the import file be?

It must be in a csv file format.

  • The file will contain a column for: Shortcut Number, Date, Amount, Comment (optional), in that order.
  • Use negative numbers for credit amounts.
  • Total of Amount column must be zero.

 

The file layout is:   

A B C D      
Shortcut Number Date mm/dd/yyyy Amount ** Comment *      

Shortcut Number (income account to credit)

Date (mm/dd/yyyy)

Amount (no $ or commas)**

Comment (optional. maybe blank but comma needed to separate fields)*

 

 

I'm getting an error message about account short codes.

Check to see if the shortcut code is in the system, and that it is not archived.

 

I'm getting an error message about the file structure, or amounts not netting to zero.

Make sure the amounts net to zero.

              Make sure the number format is correct, for example, negative numbers must have "-" signs, not   parentheses.

 

I've fixed everything, and it's still not importing

Look for odd character's such as apostrophe's in names.  Excel reads anything with an apostrophe as a text field.

You can always try downloading a "fresh" export file, then copy and paste the information from the file you are having trouble importing.  Often, doing this gets rid of format issues that are hard to identify and permits you to import without errors.

.

 

 

.

Importing Deposits

Where do I find the deposit import template?

You can find the link to the template in the import window under Process, Import Deposit.

   

What format should the import file be?

It must be in a csv file format.

The file layout is:   

A B C D E F G
Shortcut Number Date mm/dd/yyyy Amount ** Comment * Project Code* Transaction Number (1, 2, 3, etc. for each deposit) Bank Shortcut Number

Shortcut Number (income account to credit)

Date (mm/dd/yyyy)

Amount (no $ or commas)**

Comment (optional. maybe blank but comma needed to separate fields)*

Project Code (optional. maybe blank but comma needed to separate fields)

Transaction Number (1, 2, 3, etc. for each deposit)

Bank Shortcut Number (bank account to use. Primary users must use subsidiary bank accounts in one and same primary bank account. Standard users must use the same bank account for all items of a transaction.)

 

 

I've fixed everything, and it's still not importing

Look for odd character's such as apostrophe's in names.  Excel reads anything with an apostrophe as a text field.

You can always try downloading a "fresh" export file, then copy and paste the information from the file you are having trouble importing.  Often, doing this gets rid of format issues that are hard to identify and permits you to import without errors.

 

.

 

.

Importing Journal Entries

Where do I find the journal entry import template?

You can find the link to the template in the import window under Process, Import Journal Entries.

   

What format should the import file be?

 It must be in a csv file format.

 

The file layout is: ShortcutNumber, Date, Amount, Comment, Project Code, Transaction Number. In that order. Use negative numbers for credit amounts. Total of Amount column must be zero. Transaction Number must be an integer number. File Format: Shortcut Number Date Amount (negative for credit, positive debit) Comment (optional. maybe blank but comma needed to separate fields) Project Code (optional. maybe blank but comma needed to separate fields) Transaction Number (1,2,3 etc. for each journal entry)

The file layout is:   

A B C D E F  
Shortcut Number Date mm/dd/yyyy Amount ** Comment * Project Code* Transaction Number (1, 2, 3, etc. for each deposit)  

Shortcut Number (income account to credit)

Date (mm/dd/yyyy)

Amount (no $ or commas)**

Comment (optional. maybe blank but comma needed to separate fields)*

Project Code (optional. maybe blank but comma needed to separate fields)

Transaction Number (1, 2, 3, etc. for each deposit)

 

 

Related Articles:

Error message: An account with shortcut does not exist or is archived

 

 

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.