CNA L&P - Import Transactions: Troubleshooting

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

Go to the PROCESS menu to import a budget or journal entries (payroll, deposit, or general journal entries)

 

.

Importing a budget- (see also the Budget FAQ article)

Where do I export the budget file(s)?

In the Process, Budget screen

 

Problem: My budget spreadsheet won't import

Solution: Make sure the file is in an ".xlsx" format!

 

Problem: I'm not sure which budget I'm importing (e.g. current, next year, or next year +1).

Solution: The system tagged the file when it was exported so the system will know where to put the imported 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.

 

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: 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)

 

Related Articles:

CNA L&P - Imports: 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.