Create Journal Entry Tab of the Credit Card Statement Reconciliation Form

If you use cash-basis accounting, use this tab to create a cash-basis journal entry for all the cleared company-paid charges on the Charges tab of the Credit Card Statement Reconciliation form for a statement that is completely reconciled.

This tab is visible only if cash-basis accounting is enabled on the Reporting tab in Accounting System Settings Configuration. This is also not visible if the selected credit card is employee-paid.

Ideally, you create the journal entry as the last step before you close a reconciled statement. If you create and post a journal entry before all charges are reconciled, the journal entry will be missing some amounts. If you then create and post additional journal entries for a statement, this produces overstated amounts because the repeated journal entries include all cleared charges, not just the previously uncleared charges.

Contents

Field Description
Transaction Date Enter a transaction date for the journal entry.
Replace existing unposted cash journal files of same file names Select this check box if you previously created a journal entry for this statement that is not yet posted, and you want to replace it with this new journal entry. The transaction file that contains the journal entry must have the same file name as the transaction file you are replacing. You enter this name in the Cash Journal Batch Name field.
Cash Journal Batch Name Enter the transaction file name for the journal entry. It prefills with "<Primary credit card code> <Transaction Date entered on this tab> <Code for your company in Vision>." You can change the name.
Diary

This field displays only if you have set up a diary in Accounting System Settings Configuration for the fiscal period or fiscal year in which you are entering transactions.

Use this field to select a diary code for the current transaction or the group of transactions if you are processing a group of transactions, such as an accounts payable payment processing run. The diaries are used to generate diary reports that contain a set of sequentially numbered transactions that have been posted to the general ledger during the fiscal year or to specific fiscal periods. You can assign different diaries (that have different diary types) to different types of transactions.

The Diary drop-down list contains three columns. The first column displays the diary code. The second and third columns display the diary type for the diary code and the description of the diary type.

The drop-down list contains all the diaries that you set up on the Diary Auto Numbering tab in Configuration > Accounting > System Settings that have the same fiscal period or fiscal year in which you are entering transactions, or no fiscal period or year entered for them.

If you have multiple companies, the Diary drop-down list includes only the diary codes that are set up for the current company. The list also includes IC - Intercompany Diary to capture intercompany transactions.

You cannot delete a transaction after it has been saved with a diary number. If a transaction is incorrect, you can enter zero amounts for the transaction, or enter a reversing transaction.

Create Cash Journal Button Click this button to create the cash-basis journal entries for this statement.

A journal entry is automatically created for each secondary credit card that makes up a primary credit card. This includes a line item for each reconciled company-paid expense report charge and each AP disbursement that paid a voucher with a credit card. One transaction file is created for the journal entries for each secondary credit card.

Review the journal entry in Transaction Center > Transaction Lists. Then post it in Transaction Center > Transaction Posting.