A journal entry is a way to record a transaction in your general ledger. Usually entries to the general ledger would come from the posting of client invoices, receipts, vendor invoices and payments. At times there is a need to record a transaction outside of these predefined methods, this may include payroll tracking and recurring rental/lease payments.
Though typically used as a one-time record of a transaction, Workamajig allows you to create recurring and auto-reversing entries, as well as, entries that only affect your Cash Basis or Accrual Basis ledger.
Create a New Journal Entry
- From Menu > Accounting > Today-Accounting > click at top of page >Journal Entry
- Posting Date: Enter the date you want the Journal Entry to Post to the General Ledger.
- Journal Number: This will be auto-filled by the system
- Description:Enter a description for the Journal Entry
- Click Save
Prior to the Save you may also set the following, if needed:
Auto Reversing: When checked, the system will auto-generate a reversing entry on the first day of the following month. The entry will be numbered with the source journal entry number + - REV. Ex. JE100>>JE100-REV
Exclude From Cash Basis: when checked, will exclude the entire entry from the Cash Basis balances/reporting
Exclude From Accrual Basis: when checked, will exclude the entire entry from the Accrual Basis balances/reporting
NOTE: By default a JE will affect both the Cash and Accrual based ledgers
After SAVE, the Journal entry will be created with an assigned number
- Click + Add a journal entry detail. This can be done in the grid, or you can click the arrows icon along the left side to enter within line details
- tab to next field in grid
- tab past last field in line will create a new line
- once finished adding lines, click outside the grid. The system will auto-save the entries.
- Click POST
Edit Journal Entry
To edit a Journal Entry header information, go to the journal entry, click on Edit icon located next to the Posting Date. A screen will display the fields that are available for editing.
To edit a line, click into the line field
To add a line, click insert row.
NOTE: In order to edit these fields or add/edit/delete lines the JE must first be unposted, with the exception of the Description.
Copy A Journal Entry
You may copy a journal entry at any time. Go to the journal entry you want to copy, click ...more at top of page>Copy.
Select to create a Single or multiple copies
Single Copy: The system will create>display the copied journal entry.
Enter Number Of Multiple Copies: select and enter the number of copies. The system will create one journal entry for each succeeding month. The Posting Date will be set to the same Day of the month as original.
The system will assign the next available JE number and copy all detail entries. You are able to edit the new entry prior to posting.
NOTE: If you need the "copied" journal entries to be on a specific date, duplicated in a time frame other than monthly or need to keep the Journal Entry numbers in line with the current periods, Next Number, use the Recurring/Scheduled function described in the next section
Recurring/Scheduled Journal Entries
Workamajig allows you schedule and auto-create Journal Entries for bank transfers or asset depreciation.
Once a Journal Entry has been created, you are able to setup a schedule to create a copy of the Journal Entry at a designated time interval and for a set number of times. In order to keep the integrity of your Journal Entry ordering numbers, the actual transaction will not be created until the designated date, and will use the next available number in the system. The copied transaction can be edited to fit the given period, if needed. It will also contain the connection to the source Journal Entry. Each new entry must be posted to affect the GL
Create a New Schedule
- From the original/source Journal Entry, click on ...more>Create Schedule
- A "new schedule" screen will now be available: click the Edit pencil icon to the right of Settings
- Edit the appropriate fields:
- Frequency: select the frequency you want a new Journal Entry to be created (None, Daily, Weekly, etc.).
- Next Date: select the date you want the recurrence to continue from. Default equals today's date
- Reminder Option: select from the dropdown list how you want to be notified
- No Reminder: The new entry is created and no reminder is sent
- Show Reminder: based upon the Days in Advance, upon login to Workamajig a message will dropdown asking you to create the new Journal Entry or cancel. As this can be sent to multiple people, the first person to create or cancel will be accepted by the system.
- Automatically Create: based upon the Days in Advance, the new Journal Entry will be created and a notification will go out to selected individuals.
- Number Remaining: enter the number of times you want the recurrence to run. As each Journal Entry is created, this number will be reduced by one. Default equals 99,999.
- Days in Advance: enter how many days prior to the "Posting Date" do you want the recurring Journal entry to be created. Default equals 0
- Create As Approved: check if this does not need to go through an approval process
- Active: the schedule is active and will auto-create entries. If unchecked, it is inactive and no new entries will be created. Default: Checked
- click Save commit the recurrence to the system.
GENERATE: overrides the recurrence settings to create a new Journal Entry. The entry will be created based upon the Frequency and Next Date. Each time you click Generate it will create the next transaction in line and the Number Remaining will be reduced by 1. NOTE: You do not need to click Generate, the system will auto-create your journal entries based upon the schedule settings.
POST: Individual Journal Entries can be posted or you can Post all transactions via Accounting>Post Transactions
NOTE: The Source Journal Entry will display a section that show the details of each recurring entry. Double-click on the desired recurrence to open that specific Journal Entry in a new window.
Once a schedule is created the source and all child journal entries will now display ...more>View the Schedule.
Stop Scheduled Journal Entry
- From the source or child JE, click ...more>View the Schedule
- click Edit pencil icon to the right of settings
- uncheck Active