Accounting FAQs
- How Do I Enter Payroll into Workamajig?
- Where can I find a 1099/1096 Tax Form?
- How should I handle Credit Cards for AP?
- How should I handle Credit Cards for AR?
- What is a rollup account?
- How do I post to Work in Progress (WIP)?
- How do I create a refund check for a client?
- How to accept a refund from a Vendor?
- Where can I get a "Comparative Balance Sheet Report"?
- How to hide employees Hourly Cost/Labor at Net?
- How do I process Pro Bono work?
- What makes time entered Billable vs. Non-Billable?
- How do I VOID/Close an Advance Billing/Deposit Invoice?
- How to edit/delete a Vendor Invoice after the Payment has been Applied/Voided?
- How do I manage Asset Depreciation?
- How do I troubleshoot AP/AR Not In Balance?
How do I enter Payroll into Workamajig?
This is done by creating a Journal Entry for each pay period. Its then up to you to determine the amount of detail within the JE and what GL Accounts it should track to. This can be set to recur each month as well, so you just change the line amounts each time without having to enter a new JE from scratch.
Where can I find a 1099/1096 Tax Form?
For the use with our 1099/1096 Printing, our engineers designed the US Tax forms for 2014 to match the forms we obtained from Staples.com:
1099 Misc forms
Item 356860
Model STAX511
1099 Int Forms
Item 356846
Model STAX511NT
Includes Envelopes
1096 Summary Form
Item 356864
Model STAX10961
How should I handle Credit Cards for AP?
There are 2 ways of handling credit cards from an AP point of view:
Credit Card Connector and Charges
- This feature allows you to set up the credit card in Workamajig and process the charges daily.
- Please refer to the Credit Cards Overview guide to learn more.
Manual Tracking
-
This method is outlined below in a detailed and simple process:
Manual Tracking of Credit Card Charges:
The detailed process is as follows:
-
Setup your credit card account as a cash (bank) account in GL Accounts.
-
For the charge to the credit card, enter each transaction as a vendor AP invoice for the vendor company where the purchase was actually made.
-
Select the AP GL account in the main window and the actual expense or COGS account on the line items—charging a project if applicable. Approve and post the invoice.
-
Pay it out of the credit card cash account. Approve and post the payment.
-
When you receive the credit card statement/bill, reconcile that credit card account from the statement.
-
Setup the credit card company as a vendor.
-
Enter the credit card statement/bill as a vendor AP invoice. Select the AP GL account in the main window and the credit card cash account on the line item. Approve and post the invoice.
-
Pay it out of your regular checking account. Approve and post the payment, and you're done.
The simple process is as follows:
-
Setup the credit card company as a vendor.
-
Wait until the credit card monthly statement arrives to enter the charges.
-
Enter the credit card statement/bill as a vendor AP invoice. Select the AP GL account in the main window and the actual expense or COGS account on the line items—charging a project if applicable. Approve and post the invoice.
-
Pay it out of your regular checking account. Approve and post the payment, and you're done.
NOTE: Users can also enter expense reports for credit card charges and set the vendor on the expense report to be the credit card vendor instead of themselves. You will then create the vendor invoice, as usual, and select this invoice for payment to the credit card vendor.
How do I handle Credit Cards for AR?
If you have elected to accept credit card payments from a client, you will need to set up the Credit Card Processing features. At this time, the Workamajig system uses PayFlowPro only.
What is a Rollup Account?
A Rollup Account is Workamajig’s definition for what might be called a Header Account or Summary Account in other systems. For example, in your Chart of Accounts, Agency Gross Revenue (400) would be the Rollup Account for 405, 410, 415, 420, etc. On your Balance Sheet, you can show the Rollup Account in summary or show in detail with the Sub-Accounts.
- Please refer to the GL Accounts guide for more information.
How do I post to Work in Progress (WIP)?
When you "Post WIP to the GL", approved and unbilled time will post into WIP by debiting Agency Time (Asset) and crediting Agency Time Adjustment (Income) account specified in the Control Account screen.
When labor is then billed after being posted to WIP, it will then reverse out of WIP the next time WIP is posted by crediting Agency Time and debiting Agency Time Adjustment accounts.
For Other Expenses (including approved Misc Costs and Expense Reports) left unbilled, it will post into WIP by debiting Other Expense (Asset) and crediting Rebillable Expenses (Income) accounts specified in the Control Accounts screen.
When other expenses are billed, it will reverse out of WIP the next time WIP is posted by crediting Other Expense and debiting Rebillable Expenses accounts.
For approved production vendor Invoices that is left unbilled, during the posting of WIP to GL, it will reclass the expense by debiting the Production Invoice Accrual (Asset) and crediting the COGS account based on the Item selected on the line of the vendor invoice.
When the vendor invoice is billed, it will reverse out of WIP the next time WIP is posted by crediting the Production Invoice Accrual and debiting the COGS account based on the Item selected on the vendor invoice line.
-
Please refer to the Post Work In Progress guide for more information.
How do I create a refund check for a Client?
These steps assume that the client has an unapplied credit memo that you need to refund to the client:
- Create a regular client invoice that debits AR and credits SUSPENSE for the amount of the open credit memo. The client invoice, by default, will target/credit your AR account. The client invoice line needs to be created with the Sales GL Account set to your desired SUSPENSE account.
- Select the Apply Credits tab on that client invoice and apply the credit memo against it to close out both client invoices.
- Setup the client as a vendor.
- Create a vendor invoice for the vendor for the refund amount. The vendor invoice will need to credit AP and debit SUSPENSE. The vendor invoice, by default, will target credit your AP account. The positive value vendor invoice line needs to be created with the Expense GL Account set to the SUSPENSE account used in your credit memo in step I.
- Go to Select Invoices for Payment under the Purchasing menu and create the payment.
- Go to Print Checks screen under the Purchasing menu to print the refund check.
In the case of the refund is due to an unused portion of an Advance Bill Client Invoice:
If the advanced bill was not paid and not applied:
- Create a credit memo invoice. The client invoice credit memo, by default, will target/credit your AR account. The negative value client invoice line needs to be created with the Sales GL account set to your desired Suspense account.
- Apply to advanced bill invoice.
- Create a regular client invoice. The client invoice, by default, will target/credit your AR account. The positive value client invoice line needs to be created with the Sales GL account set to the same Sales GL account selected in step I.
- Apply advanced bill invoice to that invoice
- Post all
This clears the open AR amount and the Unapplied Advance Bill amount from the Advance Bill client invoice.
If the advanced bill was paid by the client:
- Create a regular client invoice
- Apply the advance to the invoice.
- Set up the client as a vendor
- Create a payment to the client-vendor. Choose the option to apply to an expense account, but instead of an expense account choose the sales account from the regular invoice.
- Print/post
In the case of the refund is due to an Unapplied Amount from a client receipt:
If you cant edit the Receipt:
- Create a regular client invoice that debits AR and credits SUSPENSE for the amount of the open unapplied amount. The client invoice, by default, will target/credit your AR account. The positive value client invoice line needs to be created with the Sales GL Account set to your desired SUSPENSE account.
- Select the Apply Prepayment on that client invoice and apply the unapplied amount against it to close out the client invoice and unapplied amount.
- Setup the client as a vendor.
- Create a vendor invoice for the vendor for the refund amount. The vendor invoice will need to credit AP and debit SUSPENSE. The vendor invoice, by default, will target/credit your AP account. The positive value vendor invoice line needs to be created with the Expense GL Account set to the SUSPENSE account used in your client invoice created in step I.
- Go to Select Invoices for Payment under the Purchasing menu and create the payment.
- Go to Print Checks screen under the Purchasing menu to print the refund check.
- Print/post
If you can edit the receipt:
- Unpost the Receipt and choose a Suspense Account to apply to in the Sales line. Repost.
- If you haven't already, convert the Client to also be a Vendor.
- Create the payment, add an the expense line and use the same account used from the receipt.
- Go to your Print Check screen for processing.
How to accept a refund from a Vendor
If it is a refund only and no billing back to the client, then enter as Journal Entry to debit cash and credit COGS/Expense account.
If you need to bill the credit back to the client, then enter Journal Entry as described above first, but then enter a Misc Cost on the related project with negative net/gross to bill back to the client.
Where can I get a "Comparative Balance Sheet Report"?
Typically this is referring to a report in Workamajig that we call the "Statement Of Cash Flows" report in Financial Reports.
- Please refer to the Financial Reports guide for more information.
How to hide employees Hourly Cost/Labor at Net?
To hide employees Hourly Cost (Labor Net) information from certain users:
- Uncheck View Labor Net Cost Per Hour in Lookups and Reports in their Security Group setup;
- In Security Group Options tab for selected Custom Report Datasets, do not check/allow for the following datasets:
- Time Details Data
- Time Details Data (with Employee Custom Fields)
- Employee Data
- Project Summary *
- Project Cost Transactions (Labor Net)
- Project Summary Data with Team *
* Project Summary datasets include total labor net but not individual's hourly cost rate.
NOTE: By default, no security group starts with the rights to any of the custom report datasets.
Some reports or listing screens may show a column labeled Labor Net. The column may be hidden, however, if it is visible, the visible amount will be equal to Labor Gross.
Project Level
Project Dashboard: if selected to show Actual Profit shows Labor Net. This is an aggregate number, no detail available
Project Budget screen: will hide Labor Net column. If labor net column was already selected, the Labor Net = Labor Gross
Project Transactions screen: will hide Labor Net. If Labor net column was already selected, the Labor Net = Labor Gross
Project Listing screen: there is a column Labor Net. This is an aggregate amount, no detail available
Standard Reports
Project Financial Reports
Project Budget Analysis: No Net visible
Time Productivity Report: Net Is Visible
Financial Reports: all reports under this section will show Labor at Net.
How do I process Pro Bono work?
The typical recommendation is to bill the project for the full value of the work. Create a credit memo to apply against it. And lastly, send the client the invoice so that they can see the value of the work being done at no charge.
The credit memo would either go against the original sales account on the positive client invoice or if you set up a Charity income account and post to that account, which will make that account go negative. So when they look at their sales account balances, they would see the positive income going to agency fees, for example, and then a negative amount going to a Charity income account.
This is called a "contra-income" account. "contra" simply means that it'll hold a balance that is negative instead of being positive.
What makes time entered Billable vs. Non-Billable?
Billable/Chargeable Hours = Hours entered against a Billable project with a service rate higher than zero.
Non-Billable/Non-Chargeable Hours = Hours entered against a Non-billable project; a billable project where the billing rate of the service is zero.
How do I VOID/Close an Advance Billing/Deposit Invoice?
- Create a new regular client invoice that matches the setup of the advance bill (same Client, Amount, Project, etc).
- Add a Line on the new invoice for the amount of the Advance. Populate the GL Account to a Sales Account (remember the account used).
- Apply this new invoice to the advance bill. This will reduce the Unapplied Amount to $0. Post the invoice.
- Open the Advance Bill. Make sure its Posted. Then click on Write Off.
- A new invoice will appear with the line going to your bad debt account. The open amount of the advance is now reduced to $0.
- Change the GL Account to match the account used on the new invoice from step 2. Post the invoice.
- You are now done. Ensure all three invoices are posted for these to reflect on your Financial Reports.
Please review Advance Bill Invoices for further details regarding this topic.
How to edit/delete a Vendor Invoice after the Payment has been Applied/Voided?
When you Void a Payment, the system assumes the Payment was the issue and not the Vendor Invoice. So the invoice is still available to pay, and the original payment and voided payment are linked to the Vendor Invoice. Which locks the Vendor Invoice from being deleted.
So if the Vendor Invoice was an error, then you will need to unlink the Original Payment and the Voided Payment from the Vendor Invoice, before you can edit/delete the invoice.
From the Unposted Vendor Invoice, click on the Payments tab to located the two payments. Then open each payment and un-post them, edit the Invoices section and remove the lines that apply them to the invoice. Save. Now close and reopen the vendor invoice, and you should now be able to edit/delete the vendor invoice.
How do I manage Asset Depreciation?
You can set up a scheduled Journal Entry to schedule this type of accounting need in Workamajig.
How do I troubleshoot AP/AR Not In Balance?
We have a guide called Troubleshooting Out Of Balance that goes into detail of how to troubleshoot this beyond just the Not In Balance message from Today Accounting or Aging Reports.