PSA L&P - Imports: Journal entry import

Journal entry import

Where do I find the journal entry import template?

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

   

What format should the import file be?

It must be in a csv file format.

 

The file layout is: Shortcut Number, 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

How to import transactions and troubleshoot

An account with the shortcut XXX does not exist or has been archived.

 

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.