PSA L&P - Imports: Deposit import

Deposit import

Where do I find the deposit import template?

You can find the link to the template in the import window under Process → Import Processes → 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.

Related Articles

How to import transactions and troubleshoot

 

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.