Payroll is a high risk area in businesses for fraud - especially because you can’t see the details from a bank statement. To help monitor payroll payments on an ongoing basis, or to review historical pay periods, use our simple Excel macro to help flag suspicious transactions.
Macro must be used in Microsoft Excel. It contains 4 tabs including: instructions, data input tab, scatter graph, and total pay per period line graph.
Use the Workman Forensics Fraud Detection Made Simple Excel worksheet to guide you through the ways in which your money receives and spends money to identify potential areas for theft.
Worksheet is recommended to be used in Microsoft Excel.
When you open the spreadsheet, make sure to click the “Enable editing” button at the top. The fields that need information entered are unlocked for you.
Use the Workman Forensics Break-Even Business Model Comparison Excel Worksheet to evaluate different business model scenarios. This worksheet allows you calculate the minimum monthly or daily revenue needed to cover fixed and variable costs and compare the results of various scenarios side by side.
Worksheet is recommended to be used in Microsoft Excel for Mac users.
When you open the spreadsheet, make sure to click the “Enable editing” button at the top. The fields that need information entered are unlocked for you.
Use the Workman Forensics PPP Funds Worksheet to organize the uses of your PPP loan funds for the bank to maximize forgiveness. This worksheet allows you to categorize the expenditures in the approved expense categories which then recommends the basic supporting documentation you will want to provide to your lender. The worksheet also tracks your payroll costs as a percentage of the loan funds to let you know when you have hit the 75% requirement.
Worksheet is recommended to be used in Microsoft Excel. It contains 1 tab including instructions.
When you open the spreadsheet, make sure to click the “Enable editing” button at the top. The fields that need information entered are unlocked for you.