Journal Template Entry
Contents
Overview of FW10T
Journal Templates allow you to configure documents that you use on a regular basis. You can then use these templates to create general or recurring journal entries. To create a journal template:
- From the DDI Connect main menu, double-click FundWriter
- Double-click Journal Template Entry. You will see a screen similar to this one:
Create a new template
To create a new journal template, click the New button on the toolbar. You will now see this screen:
Enter the template number you wish to use, or leave the field blank to use the next available template number. Click OK. You will now see this screen:
Document Setup Tab
The following fields are available on this screen:
| Field | Description |
|---|---|
| Memo | If you wish to enter a brief memo on this template, you can do so here |
| Amount | Enter the total document amount |
When you have finished entering the information, click the Line Items button or the Line Items tab
Line Items Tab
When you click Line Items, you will see this screen:
To begin adding line items, click the Add button on the toolbar. The fields now become available for editing:
The following fields are available on this screen:
| Field | Description |
|---|---|
| Reference | The Reference field is a freeform text box that can be used as a brief description to indicate the purpose of the entry. For example, a loan number, gift number, or other notation |
| Line amount | Enter the dollar amount for the line |
| Percent | The Percent field will automatically update based on the dollar amount entered in the Line Amount field. You can also enter a percent here to automatically update the Line Amount field |
| G/L account | Enter the G/L account or click the list icon to select from a list of active G/L accounts |
| Due | If you click the drop down, you can select From or To. If you make a selection here, the Due From/Due To transaction process is activated. This feature can be used for things such as transferring funds from an unrestricted to a restricted account, or from a temporarily restricted to an unrestricted account |
| Memo | If you wish to add a memo to the transaction, you can do so here. For example, you might note the purpose of the line item, such as "Correcting Loan Transactions for June 2012" |
When you have finished entering the information, click OK. The system will populate the lower portion of the screen with the line information, and prepare for Line 2 entry:
Repeat the above procedure until you have entered all of the appropriate debits. When your total reaches 100%, the next line item automatically becomes a credit transaction:
The DDI system utilizes T chart accounting, and requires that each journal balance in full before it can be posted to the General Ledger. The total debits and total credits must balance completely before you can proceed with posting.
When you have entered your debits and credits, your screen will look similar to this:
If you need to edit a line item, you can do so either by double-clicking the line item or by clicking the Edit button on the toolbar. When you have made your changes, click OK.
Review the template. If you are satisfied that the information is correct, click Save.
Actions
If you click the Actions button on the toolbar, you will see the following options:
Copy from an existing journal document
You can create a template by copying information from an existing journal document. To begin, click Actions and select Copy from an existing journal document:
This will launch the Journal Document Inquiry screen:
Enter the parameters you wish to use to search for the document you want to copy. When you have located it, you can double-click it or click it once to highlight and then click the Select button to proceed. The following screen will launch:
You can enter a template number to use or click OK to use the next available template number. The template will now appear with all of the information populated. Modify the items you need to change. When you have finished, click Save to retain your changes.
Edit an Unfinished Document
If you have an unfinished template saved, you can resume modifications. From within the Journal Templates screen, click Actions and select Edit Unfinished template. This will recover the most recent unfinished template and allow you to continue working on it. When you have finished, save your changes.
