As a member of the Accounting Staff, you will want to be familiar with:
If you do not see items described in this guide when logged in to Workamajig, please contact your agency's Workamajig Administrator(s) or reach out to firstname.lastname@example.org.
Your billing cycle should be conducted in the following Order: 1) Retainer Billing, 2) Media Billing, and 3) Generate Project Billing Worksheets.
The reason behind this order is to clear out all transactions related to Pre-approved Invoicing, i.e., Retainer, Media, your normal project billing, that typically requires an approval process, and billing worksheets.
- From Menu > Billing > Mass Billing > Retainers.
- In the Client text box, enter a client ID, if you want to search retainers for a specific client.
- In the Through Date text box, enter a date to search for transactions through. If you only want to bill expenses through the end of last month, the through date would be the last day of last month.
- In the Invoice Date text box, enter the invoice date that should be used on the generated invoices.
- In the Posting Date text box, enter the posting date that should be used on the generated invoices.
- Click the Search button to find all retainers to be billed.
- Select the "checkbox" next to each retainer that you want to bill.
- Click the Generate Invoices button at the bottom of the list. This will create the invoices and send them in for approval.
- From Menu>Billing>Mass Billing>Media
- Set the "through date" for your media orders. Typically these will be out 3-6 months.
- Set "through date" for Vendor Invoices. Typically this will be set to a current period.
- Select the Orders and Voucher you wish to bill for.
- Click Generate Invoices.
The use of Billing Worksheets is ideal for agencies that handle many projects at one time and require input from account managers in the billing process.
This integrated billing process allows you to complete the review process faster, with fewer mistakes and missed billing opportunities.
Overview of the steps taken when using Billing Worksheets:
Generation: The accounting department initiates the generation of billing worksheets. They are forwarded to the designated reviewer(s).
Review: A designated reviewer (the Account Manager on a project) can review, edit, and transfer transactions. The billing worksheet is then forwarded back to accounting for approval.
Approval: A designated approver can edit transactions and approve billing worksheets.
Create Invoices: Once approved, the accounting department can turn the billing worksheets into client invoices.
There are a couple of options that can be set at the project level to help determine how the project should be billed:
Billing specifications should be set at the project level under the Project Setup > Billing tab:
Billing Method (Time and Materials, Fixed Fee, or Retainer)
Labor Billing Rates
Purchasing and Media Markups
NOTE: This information can also be set at the Client level and defaulted onto projects and billing worksheets when they are created, further simplifying the setup.
On the Accounting tab of the project, the optional Billing Schedule can be edited to designate the project's billing to be incremental. This will inform the system to flag this project to create a fixed fee billing worksheet based on the billing schedule provided on the project.
NOTE: This step is not necessary for Retainers, as this information is defined in the Retainer Plan.
From Menu > Billing > Billing Worksheets > Generate
Specify criteria such as client ID, through date, and options.
Click the Search button to see a list of projects meeting your criteria.
Select the projects you want to create the billing worksheet for. We recommend that you use the select ALL box.
Click Generate Worksheet button.
Each project will have its own billing worksheet to be reviewed and approved. If using the One Invoice Per Client option, for example, then the worksheets will appear with a Master Billing Worksheet.
Approve Billing Worksheets
Once the AE from the project is done with the worksheet, they will submit for approval. The worksheet will now be in your My Items to Approve box. This allows you to review what the AE has asked to be done for the client project. You are able to edit and approve the worksheet or reject it with comments sending it back to the AE for changes. Once fully approved, the worksheet is ready to become an invoice.
Create Invoices from Billing Worksheets
Prior to generating invoices, go to Menu>Billing>Billing Worksheets. Confirm that all worksheets for the period have been Approved. Cycle through the listings, "In Review" and "Submit for Approval". These should be empty.
From this same screen, click on the generate Invoice icon, located along the left side.
From the Generate Invoice screen, all approved billing worksheets and master worksheets can be found in the Create Invoice tab of the Billing Worksheet menu window. Simply, indicate which worksheets you would like to bill and press the Generate Invoices button.
All related billing worksheets must be approved before the master worksheet can be approved.
Search for Saved Billing Worksheets.
Billing Worksheets are permanently stored in the database to provide an audit trail of the billing from Menu > Billing > Billing Worksheet > Search.
When you open a billing worksheet to its Worksheet Settings tab, you will see a summary of the key information. The Details tab of a billing worksheet shows the transactions that were automatically included on the worksheet during the initial generation process.
NOTE: Projects can only have one billing worksheet in progress at any time. Also, no transactions can be modified outside of the Billing Worksheet while they are included on a billing worksheet currently in progress.
How an invoice prints out are determined by the Invoice Layout selected, and how the invoice is generated using the above methods. It is suggested that you generate the invoice with as much detail as possible, then use the invoice layout to print to the level of detail/summary you want.
You will be tracking purchasing via the following locations:
Menu>Reports>AR Reports>AR Aging
How To Enter A Purchase Order
For Project related purchase orders, you will probably receive a notification from the Project Manager regarding the need to create an order. Go to the project.
From the Project: Estimate
From the Project:Budget: Estimate>>open the appropriate approved estimate.
Click on the Create PO button in the top right corner.
Select the line(s) you need to create a PO for and click Create PO.
Because this may create more than one PO, you will need to go to the PO listing screen (Menu>Purchasing>Purchase Orders) to review the orders you have just created.
Open the appropriate Purchase Order to review contents.
You will note that all of the information has been prefilled for you.
Click on Address/Instructions tab
Enter in appropriate information needed for the vendor. Click the Actions: Approve to approve the order and allow the billing of the order to the client.
How To Enter A Voucher/Vendor Invoice
When a voucher is received from your vendor, you want to make sure you tie the voucher back to the order.
From the Edit Vendor Invoice screen: enter in the Order Number associated with the voucher.
Once selected, the screen will refresh and bring you directly to the order lines.
Check the order line. If the voucher is for the same amount as the order, Click Done.
If the voucher is higher or lower, enter the amount in the Open Net column>Check Close checkbox>Done.
You will be returned to the Edit Invoice Screen.
Fill in the Invoice Number and Invoice Date>> SAVE.
Click Approve button in the top right corner, or Submit if you are not designated as a voucher approver.
If you’ve set up a credit card provider to automatically download credit card charges nightly, then you can use this screen to match up credit card charges and allocate them to the correct project.
You can also use this screen to match up the manually created credit card charges against the activity downloaded from the bank.
If your credit card is not listed as a supported provider, you can import credit card activity using the .ofx file import.
The purpose of the connector is to allow you a chance to review and code your incoming charges to the correct project and other settings. This is the screen your people who use the credit cards can come and correctly code them. They will only be able to see cards that they have been given access to use. The top grid shows incoming charges. There are three actions you can take:
1) Code and process the charge
The typical choice will be to code the charge to the correct project, office, item, purchased from etc. then you can shift or ctrl-click to select multiple lines and press the Process button. The system will then take the selected rows and turn them into credit card charges.
2) Match the transaction to an existing charge
Sometimes you need to manually enter a charge such as if you were using the select invoices for payment screen and decided to pay a vendor invoice with a credit card. Any manual charge that has been entered and not matched to an incoming charge will show up at the bottom of the screen. To match an incoming charge to an existing one, highlight both the transaction and the unmatched charge below and press the Match Entries button on the bottom grid. This will cause both rows to be removed (Marked As Processed).
3) Mark an incoming charge as "Processed"
When you first start using the system, you may bring in a number of incoming charges that you have already handled some other way and you really just want to make them go away. Select the rows you want and press the "Mark as Processed"button. These charges will then be removed.
LINKING ONE CHARGE TO MULTIPLE VENDOR INVOICES FOR THE SAME VENDOR
It is possible to link a charge to an existing vendor invoice or even multiple vendor invoices, but this is typically done through the select invoices for payment screen. When selecting invoices for payment, you now have the option to select a credit card as a form of payment instead of a check. Then, when the electronic charge comes in, you can match the incoming charge with the existing charge.
But if you are going to link to vendor invoices, you need to first put in a vendor. If you need to apply it to multiple vendor invoices, then customize the columns on the grid to show the Split Invoices column. If this box is checked, the system will show you a list of open vendor invoices for the selected vendor.
You can't code a credit card charge to both a project and a vendor invoice. It is one or the other.
APPLYING ONE CHARGE TO MULTIPLE PROJECTS
You can also apply a charge to multiple projects. Customize the columns and select the split projects column. When this column is checked, you can access an input grid. This allows you to add in each project and task and how much each project should get.
Approving The Charge
Once you process the transaction(s) from the connector screen, those then get turned into Charges that need to be approved. Whoever is set as your credit card approver will see these charges appear in their My Items To Approve widget.
How To Pay Your Vendors
Paying vendors are usually done at the month's end, but can be performed anytime.
Menu>Purchasing>Select Invoices For Payment.
Select the appropriate Filters, if necessary, and click Search.
Invoices Billed to Client: This restricts results to only vouchers or orders that have been billed to the client.
Invoices Paid by Client: This restricts results to only vouchers or orders that have been billed to the client and the client has paid the invoice.
- Select the payments that you would like to pay.
- Select the Bank Account to use for the payment.
- Enter the Payment Date that will be set on the Check/Payment.
- Click Create Payments.
Select the Cash Account. The payments associated with the account will auto-display.
Click Print Checks: This will create a PDF file that will be sent to the printer that contains your Check stock.
Following the printing, the screen will have refreshed to show the Confirm Printing screen.
Click Confirm Printing: this will set the check number on the payment.
You will be tracking purchasing via the following locations:
Menu>Reports>AP Reports>AP Aging
Workamajig allows you to reconcile a selected G/L account against your monthly statement. You are able to reconcile any general ledger account in Workamajig. Typically, you would reconcile bank accounts, cash accounts (such as petty cash), and credit card accounts. You should systematically reconcile accounts each period, so you can quickly detect bank errors, match real-world data with Workamajig data, and identify possible suspicious activity.
The reconciling run is saved for each account reconciled. This allows you to print previous reconciliations prior to starting a new one.
NOTE: The Reconcile process does not affect your GL balances. This is used as a checksum for your accounts.
Account Reconciliations Listing
The account reconciliation listing screen provides a summary level view of all account reconciliations. You are able to modify the view to display the information that is pertinent to your team. You may also view the data in PDF or export via CSV and Excel file formats.
From Menu > Accounting > Account Reconciliations.
Click the button to start a new reconciliation.
In the GL Account select the correct account.
In the Statement Start Date text box, enter the beginning date from your statement.
In the Statement Ending Date text box, enter the ending date from your statement.
In the Beginning Balance text box, this should be the same as your closing balance from the last reconcile.
NOTE: This number is calculated by adding together all credits/debits that have targeted the GL account, including journal entries, payments, and receipts since the beginning of time, plus any other increases/decreases that have been entered on individual reconciliations.
In the Statement Balance text box, enter the ending balance from your statement.
Opening Reconciliation: Leave this unchecked.
Cleared Opening Transactions: Enter in any transactions that had not cleared the bank during your Go-Live process. Typically this will be left blank.
Filter Dates: Enter the right-side date only. This will ensure that all prior transactions will be accounted for.
Selected Increases: Shows the number of increases selected on the lower left side of the screen.
Selected Decreases: Shows the number of decreases selected on the lower right side of the screen.
Selected Balance: Shows the "Bank Balance">>Beginning Balance + (all increases +all decreases).
Statement Difference: Shows the difference between the Statement Balance, and all selected increases and decreases.
The reconciliation screen shows additions/Increases on the left-hand side and deductions/Decreases on the right-hand side. The outstanding difference is shown at the top of the screen.
If you need to enter any adjusting entries, you can click save (not save and finalize) at the top of the screen. This will save your work up to this point, and allow you to go and enter other entries into the system. You may need to enter journal entries for bank charges or other adjustments. You can then come back later and select the account from the list of reconciled accounts, and resume your work.
Once you have completed your reconciliation and the difference amount is equal to 0, you may click on the save and finalize button. This will save your work and mark all selected transactions as cleared.
NOTE: Once transactions are "Cleared" via Account Reconciliation, they will be locked from further editing. If you need to make an adjustment to a transaction(s), Open the reconcile that contains the transaction and click the OPEN button in the top right corner of the screen. You do NOT have to remove (uncheck) the transaction.
Posting Transactions To The General Ledger
In Workamajig, in order for your transactions to be seen in General Ledger and therefore available for financial reporting, each transaction must be approved and then, Posted. There are two methods of Posting transactions: 1) Single Method - via the approved transaction screen, ie. Voucher, Client Invoice, or payment, and 2) Batch Method - via the Post GL Transaction screen.
Which Method Should I Use?
The method that is best for you is dependent on the number of transactions and how your agency is organized.
Single Method - Each item is posted after approval. This is generally used when the same person that approves the item will also post the item.
Batch Method - Blocks/All Items are posted at once. This is generally used when the person approving the invoice is different than the accounting person, or you prefer a review process prior to committing items to the General Ledger.
When Should I Post?
This is truly a preference for your agency. Obviously, if using the Single Method, it would be at the time of approval. For the Batch Method, many will review and post all items that were approved that day. Some will wait until the end of the week, so it is truly up to you. However, before running any financial reports, all transactions for the subject time period must be posted to ensure the accuracy of the reports.
Is Posting Date Important?
Yes! The posting date set on the item will determine when it will affect your General Ledger, and therefore your financial reports. By default, when you create an invoice or payment, the Posting Date will be auto-set to "Today's" date.
In the case of Client Invoice and Receipt, for example, the receipt posting date will determine when the invoice has been "paid" and therefore be removed from the AR Aging report.
How To Post
Following the approval of the item, a Post button will appear in the top right corner of the screen. Simply click the button to Post.
Ex. Client Invoice.
The Batch method allows you to gather and review all items prior to posting. We assume that you already understand how to approve the subject items.
Menu>Accounting>Post Transaction to GL
The Post Transaction screen is divided into 3 parts: 1) Select a Report, 2) Search Options, and 3) Results Grid.
Select a Report
Based upon the selections made in the Search options, you are able to create a PDF report for the following:
- Missing Transactions - Shows all transactions that are sent for approval, aren't sent for approval, or, in the case of payments, no check number.
- Preposting by Account - Shows all transactions that are ready for posting grouped by the target GL Account. It will also show transactions that will not post due to the lack of a designated GL account.
- Prepost by Transaction - Shows all transactions that are ready for posting grouped by the Invoice, Voucher, Payment, or Receipt number. It will also show that the item can not post due to the lack of a designated GL account.
This area allows you to designate what items will flow into the reports or results grid.
- Starting Date: Sets beginning date for looking at items
- Through Date: Sets end date for looking at items
NOTE: Many will leave both of these blank to ensure that all possible transactions are captured.
- Check Boxes: Select the appropriate checkboxes to view appropriate transactions to display. Selections are Vendor Invoices, Payments, Client Invoices, Receipts, Journal Entries, and Credit Card Charges. If a box is not selected, then no transaction from that section will be reported on.
It is recommended that prior to running the company financials, you select all boxes and ensure that all transactions for the appropriate time period have been posted.
This area shows all transactions based upon the selected search options. Once the posting routine has completed, it will display items that the system was unable to post.
In the Results Grid, check the box associated with the item line. To select all, check the box in the column header. Click the Post button, located in the top right corner of the screen.
Month End Procedures
Workamajig provides a way for you to perform a soft close of your financial records. It is recommended that you do this each month to help eliminate future issues with the posting of transactions and allow you to more easily find errors in your financial records and reports.
Make sure all reports are being run for the same time frame to ensure accuracy.
- Check for Unapproved Transactions - via Menu> Accounting> Post Transactions, from Select a Report, choose Missing Transactions Report. Select the relevant Through Date. Click PRINT. This will show you transactions that have not yet been approved.
- Post all Transactions - It is recommended that you perform this step on a Daily or Weekly basis. This is a 2 Step Process:
- a) Via Menu > Accounting > Post Transactions, from Select a Report, choose PrePosting by Transaction; select a relevant Start Date and Through Date.
NOTE: In order to ensure that all transactions are captured, you may want to leave the dates blank; select the relevant Sub-Ledgers (NOTE: only the transactions connected with the selected Sub-Ledgers will be captured in the report and subsequent Posting of the transactions): click PRINT. This provides a report on all approved transaction that is ready for posting. Any Transactions that can't be posted will display WILL NOT POST followed by the reason. Fix any problem transactions.
- b) Following the review step above, you will follow the same procedure, except this time click POST. This will post all transactions that are available and for the Sub-ledgers, you have selected.
- Run the Balance Sheet Report - via Menu>Reports>Financial Reports>Balance Sheet
- Run the Corporate Profit and Loss Report - Menu>Reports>Financial Reports>Corporate Profit and Loss
- Run AR and AP Aging Reports - The two aging reports should match the total on your Balance Sheet for those accounts with the same date range.
- AP Aging: Menu>Reports>AP Reports: AP Aging
- AR Aging: Menu>Reports>AR Reports: AR Aging
NOTE: For Advance Billing, run the AR aging report with Unapplied Advance Bill. This total should match the Advance Bill account on your Balance Sheet.
- Run Accrued Order Detail Report: You may skip this step if you are not pre-billing orders to your clients. The total will match the Balance Sheet Accrued Order account.
- Via Menu>Reports>AP Reports: Accrued Order Detail.
- Set Closing Date - When all reports have been deemed correct, you will now set the closing date to prevent any posting of transactions to a date prior to the set Closing date. This will also prevent transactions from being unposted. The Closing Date should be set to the First Day of the Next Month. Ex. To close June, set the date to 07/01/YYYY. via Admin>System Setup> GL Settings: GL Tracking Options> - select a Closing Date.
NOTE: For any corrections, typically Journal Entries, to a closed period, simply move the date back one day and post to that final day of the month. This will allow you to easily find any corrective transactions in a prior period.