In Design Manager, you can run reports on Accounts Receivable, Accounts Payable, Time Billing, General Ledger and Glossary Lists. You can also run Financial Statements like a Balance Sheet and a Profit & Loss (P&L) Report. This guide will describe each of these reports.
To access these reports, go to the left-side menu and click on Reporting. Find the report you want to run and click on the report name and enter the information to run your report.
Project Management Reports
Client Accounting Inquiry: This report provides a detail list of accounting entries made to a Project including Retainers, Deposits, Client Invoices, and Payments. You can run this report with a Client and a Project to narrow the scope of the report
Deposit Analysis: This report displays a complete accounting of Retainer and Client Deposit monies for a given Project. To run the report enter a Project code or search for a Project
Profit Analysis: This report is designed to give both an estimated and actual profit analysis for comparison. The report lists the Estimated and Actual Costs and Prices for each Active Item in a Project. The estimated profit is based on the estimated selling price from the Proposal and the estimated cost from the Purchase Order. The actual profit is derived from the Item price on the Client Invoice and the actual cost from the Vendor Invoice. To run the report enter a Client code or search for the Client. There are various ranges to narrow the scope of the report. This report as five formats to choose from:
Detail by Project: The default selection and groups Items by Project
Detail by Manager: Groups items by manager
Project Summary: Does not list each Item individually but, has one line per Project so that the overall profitability all Projects can be quickly reviewed
Sales Category Summary: Groups Items by Sales Category
Location Summary: Groups Items by Location
Order Tracking Reports
Pre-Billing: This report is designed to assist in determining which Items need to be invoiced to the respective Client. All Items that have either not been invoiced or invoiced for less than the full amount as calculated by Design Manager will be displayed, provided the Item has not been set to Inactive or Complete. There are ranges for Projects, Clients, Salesperson and Items to narrow the scope of the report. There are two formats to choose from:
Summary: The default selection. Groups each Item by Project, followed by Location within a given Project and shows the Item Reference Number, Quantity, Proposal Number, Description, Status, Estimated Price, Amount Invoiced to Date, and Quantity Invoiced to Date
Show Pricing Detail: Shows everything that the summary format shows with more Item detail
Accounts Receivable
Aged Accounts Receivable: This report provides a list of all Client Invoices in Design Manager that have not yet been paid in full by the Client. In order for a Client Invoice to drop from the report, it must be either paid in full, credited, or adjusted so that the balance due on the Invoice equals zero. Once a Client Invoice has been paid in full or otherwise closed, it will no longer appear on the Aged Accounts Receivable Aging report after the Fiscal Month in which it was closed. If the report is printed for the current Fiscal Month, the Grand Total of the Total Due column should match the balance in the Accounts Receivable Account. There are ranges for Clients, Salesperson, and Projects to narrow the scope of the report. There are four formats to choose from:
Client or Salesperson Detail: Invoices are grouped by Client or salesperson (whichever is selected) and show a detailed list of transactions for each Project
Client or Salesperson Summary: Invoices are grouped by Client or salesperson (whichever is selected) and show one line for each Project with a balance due
Deposit Slips: Will print a Deposit Slip for all Cash Receipts entered for the selected Cash Account, Deposit Slip Number (No.), and Date Range. If Cash Receipts from another Deposit Slip Number are desired to be included on the Deposit Slip Report, enter the second Deposit Slip Number in the Combine with Slip Number (Comb. w/Slip No.) field
Open Client Deposit: Shows Retainers and Deposits collected from the Client along with the application of the Deposit and/or Retainer on Client Invoices. Transactions will appear on the report until they "close" in a particular Fiscal Month which can happen one of two ways. First, if the sum of all Deposits and Retainers less the monies being applied on Client Invoices nets to zero, all transactions will close. Secondly, individual transactions can be closed when matching amounts net to zero. For example, if a Deposit for 5000.00 is recorded in one Fiscal Month, then an Invoice is generated in the following Fiscal Month which utilizes 5000.00 in Deposit, the transactions will be closed in the Fiscal Month of the Client Invoice. There are ranges for Clients and Projects to narrow the scope of the report. There are five formats to choose from:
Summary: The default selection. Shows one line for each Project with open Deposits and/or Retainers
Detail: Shows a list of open transactions for each Project
Summary with Client Total: Shows one line for each Project with open Deposits and/or Retainers and with a Client total
Detail by Receipt Type: Shows a list of open transactions grouped by receipt type
Summary by Receipt Type: Shows one line for each Project grouped by receipt type
Sales Journal: This report shows a detailed listing of all Client Invoices posted for a specified fiscal period. To run the report enter a fiscal period and there are ranges for Clients and Projects to narrow the scope of the report. There are three formats to choose from:
By Invoice Number: The default selection
Subtotal by Project
By Invoice No. w/ Account Detail
Sales Tax: This report will show the Sales Tax owed to various tax authorities for a given calendar period. To run the report enter a date range
Statements: This report will show all Client Invoices for a Client or Project that currently have an outstanding balance and are configured for emailing to the Client. Statements can be used as documentation to Clients to indicate that there are overdue Invoices that require payment. The Invoices, and any Payments that have been received, that are displayed on the Statements mirror the transactions displayed on the current Accounts Receivable Aging for the Client. There are ranges for Clients and Projects to narrow the scope of the report and there are two formats to choose from:
One per Project/Order: Determines whether or not multiple Statements are printed should a Client have more that one active Project. By default, a Statement is printed for each Project
One per Client: Shows one statement grouped by Projects if applicable
Accounts Payable
Aged Accounts Payable: This report provides a list of all Vendor Deposits and Invoices recorded in Design Manager that still have an unpaid balance with the Vendor. In order for a payable to drop from the report, it must be either paid in full (i.e., have a Check generated or selected to be paid by a Credit Card) so that the balance due on the payable equals zero or the transaction is voided. If the report is printed for the current Fiscal Month, the Grand Total of the Total Due column should match the balance in the Accounts Payable Account. There are ranges for Vendor, Client, Project, and Manager/Salesperson to narrow the scope of the report. There are three formats to choose from:
Detail: The default selection. Shows a complete list of individual unpaid transactions for each Vendor
Summary: Shows one line for each Vendor with unpaid Deposits and Invoices
Detail by Payable Type: Shows a complete list of individual unpaid transactions for each Vendor grouped by payable type
Check Stub: Displays the information printed on the stub of the original physical Check. When a Check is comprised of too many Vendor Payables to fit on its stub, the Check will print the text “See Attached” instead of listing the entries. The Check Stub report is then used to print out the stub information for such large Checks. To run the report select the cash account from which the Check was generated. Then enter the Check Number exactly as it appears on the Check
Disbursements Journal (Check Register): This report shows a list of all of the Disbursements, or Checks, for a designated fiscal period. To run the report select a fiscal period. There are ranges for Check Dates and Vendor Codes to narrow the scope of the reports. There are three forms to choose from:
Summary (Check Register): The default selection. Shows the Payee, Check Number and Date, Fiscal Month, Transaction Description, Discount, and Amount of each Check. Each Check is grouped in the respective Cash Account from which it was created and is further sorted into Computer Checks versus Hand Checks within the Account
Detail: Shows all from the summary report in addition to any Purchase Orders and Vendor Invoices Numbers with which the Check is associated
Detail with Invoice Distribution: Shows all from the Detail report along with the Expense or Cost of Goods Sold Accounts into which each Vendor Invoice or Deposit covered by the Check was posted
Open Vendor Deposit: This report shows all Vendor Deposits that have not yet been applied to Vendor Invoices. There are ranges for Vendor, Client, and Project to narrow the scope of the reports. There are two formats to choose from:
By Vendor: The default selection. Shows Vendor Deposits grouped by Vendor
By Project: Shows Vendor Deposits grouped by Project
Purchases Journal: This report shows all Vendor Payables posted for a designated fiscal period. To run the report select a fiscal period. There are ranges for Vendor and Project Codes to narrow the scope of the reports. There are two formats to choose from:
No Project Subtotal: The default selection. Shows vendor payables with the Transaction Number, Date, and Description, Payee, Fiscal Month, Purchase Order Number, Vendor Invoice Number, General Ledger Account Number and Name, and the Amount of the Payable and does not include a Project subtotal
With Project Subtotal: Shows vendor payables with the Transaction Number, Date, and Description, Payee, Fiscal Month, Purchase Order Number, Vendor Invoice Number, General Ledger Account Number and Name, and the Amount of the Payable and does include a Project subtotal
Work In Process: This report shows any Component for which a Vendor Invoice has been recorded but has not yet been invoiced the Client. The Work in Process Report is used primarily to provide the detailed transactions that comprise the current balance of the Work in Process Account. The report is also a powerful tool to ensure that purchased goods and services are being invoiced to the Clients in a timely basis. Note that this report does not consider Time Components. The range for Project can be used to narrow the scope of the report. There are two formats to choose from:
Project: The default selection. Components are grouped and subtotaled on the report by Project Code
Account: Components are grouped and subtotaled on the report by the Cost of Goods Sold Account into which the cost was posted
General Ledger
Account Inquiry: This report provides an analysis of one or more General Ledger Accounts, including the opening balance, detail transactions, and ending balance. To run the report select a fiscal period. There are ranges for Accounts, Projects, and/or Vendors to narrow the scope of the reports. There are many account types to choose from to limit the Account Inquiry Report to a particular genre of Account such as Asset, Revenue, Expense, etc.
Trial Balance: This report shows each Account in Design Manager along with the current balance of the Account shown as either a debit or a credit amount. To run the report select a fiscal month ending
Financial Statements
Balance Sheet: This report shows the Accounts that comprise the assets, debts, and owner’s investment as of a specified date. To run the report select a Month ending date. There are two formats to choose from: Balance Sheet (landscape) which shows the report laid horizontally and Balance Sheet (portrait) which shows the report laid out vertically
Income Statements (P&L)
Monthly Income Statement: This report shows the current balance and percentage of total income for each Sales, Cost of Goods Sold, Operating Expenses, and Other Income and Expenses Accounts. To run the report select the month ending date. There are five formats to choose from:
Month, Year-to-Date: The default selection. Shows the Current Month and Year-to-Date balances
Month, Year-to-Date, Budgets and Variances: Shows the Current Month and Year-to-Date balances with Budgets and Variances
Month, Year-to-Date, Prior Year: Shows the Current Month and Year-to-Date balances with Prior Year
Month, Year-to-Date, Budget YTD, Prior Year: Shows the Current Month and Year-to-Date balances with Budgets and Prior Year
Comparative: Compares the Month Ending chosen to that same month ending for the Prior Year; showing the Increase/Decrease and the Percentage of Change
Time Billing
Employee Time Analysis: This report shows both Billable and Non-billable Time Entries for a particular Employee. There are ranges for Clients, Projects, Employees, Time Activities, and Time Entry Dates to narrow the scope of the reports. There are two formats to choose from: the Employee time analysis which is the default selection and the Employee time analysis no cost which only shows time
Project Time Analysis: This report shows both Billable and Non-billable Time Entries for a particular Project. There are ranges for Clients, Projects, Employees, Time Activities, and Time Entry Dates to narrow the scope of the report. There are two formats to choose from: the Project time analysis which is the default selection and the Project time analysis no cost which only shows time
Hours Journal: This report shows both Billable and Non-billable Time Entries entered within a specified calendar period. There are ranges for Activity Dates, Clients, Projects, and Employees to narrow the scope of the report
Time Work In Process: This report is used to identify and analyze Time Entries that have not yet been invoiced to the Client. There are ranges for Clients, Projects, Time Activities, and Entry Dates to narrow the scope of the report
Glossary Listings
Sales Categories: This report shows all Sales Categories including the Cost of Goods Sold and Sales Accounts assigned to each Component Type of the Sales Category
Sales Tax Codes: This report shows a list of Sales Tax codes, names and percentages