G/L reports show journal entries from the General Ledger. They do not show time entries, out-of-pocket job expenses, or purchase orders (since these entries don’t directly affect the G/L). Instead, they show the entry-by-entry detail for the account totals shown on financial statements.
JEs can be summarized for any period of time (choosing either entry date or date posted), for one period or all periods, and for one vendor or all vendors. These options let you find the invoices for a specific purpose, such as the quarter’s purchases for vendor GOOGLE.
✳️
G/L reports show only posted JEs They're different from vendor account agings, since they show both paid and unpaid invoices (aging reports show only unpaid invoices). Unposted JEs appear only on proof lists.
👉 JEs are selected primarily by date added or date posted This option lets you show only entries added in July, for example, instead of the entire year. By entering a range of dates, you can select all entries added today, last week, or all month -- whatever time period you need. There’s no limit to which range of dates you can use.
Reports can be printed one at a time by clicking on a report name. The print window remains open after print the report. This allows you to run another report with the same criteria, or edit the selections and rerun the same report. Reports can be printed then reprinted with different selections, as often as needed.
⚠️
There is no month-end procedure required to print G/L reports. Since the account balances are updated whenever JEs are posted, these reports will always be up-to-date any time throughout the month.
Listen to a podcast about how to get the most out of Clients & Profits's most useful project management features (5:06 mins)
TO PRINT G/L REPORTS
1️⃣ From the General Ledger window, click the
Print Reports toolbar button.
2️⃣ Click on a window tab (e.g., Journals) to select the kind of reports to print.
3️⃣ Enter the search criteria you want Clients & Profits to use, such as date added, vendor, etc.
These are some common options to use with G/L reports:
📎 Fron date added, date posted Choose date added from the pop-up menu to select invoices based on the date the vendor invoiced you (i.e., the date on the actual invoice, not the date it was added into C&P) or the posted date, which is the date the invoice was posted into the G/L; this option will match the invoices with their journal entries.
📎 and period If you choose an accounting period, Clients & Profits will limit the JEs selected for the report to both the date range & the selected period. Any JE with a different accounting period will be excluded, even if it falls within the date range. Use this option to this match invoices, checks, and client payments with their journal entries in the same accounting period.
📎 From account, to account These options let you narrow down the journal entries to a range of accounts, such as just overhead expense accounts.
📎 and added by, posted by Reports can be limited to showing only JEs added by or posted by a specific staff member.
4️⃣ Click on the names of the reports you wish to print using the search criteria you entered.
5️⃣ Click
Print.
General Journal (G/L)
|
Only manual journal entries (JEs) are reported in the General Journal. The report can be printed by period and date range. The debits, credits, G/L accounts, and date are listed.
|
Purchases Journal (A/P)
|
Accounts payable invoices (APs) are found in this journal. The debit for the cost or expense account, and the credit to the AP account, are reported along with their amounts. Print the journal for one day or a range of dates. Or print for one period, or for all periods.
|
Sales Journal (A/R)
|
Accounts receivable invoices (ARs) are reported by date range or period in this journal. Both the credit to the income account and the debit to accounts receivable are listed with the amounts.
|
Cash Disbursements Journal (checks)
|
All types of checks -- vendor payments, direct disbursements, overhead checks -- are listed here. See the credit and debit accounts and the amounts, listed in check number order.
|
Cash Receipts Journal (payments)
|
Client payments and bank deposits (PMTs) are reported in this journal. Use this report to audit which bank accounts were debited, whether the entries balance, and what the total receipts were for the period or date range entered.
|
Media WIP Accruals
|
TBD
|
All journals
|
Prints everything.
|
Audit Trail
|
Audit an account’s entries, or print a range of accounts totaled account-by-account. The audit trail can be printed for a range of dates and periods. Print for a specific job, client, or vendor to see how it affects the account.
|
Auto-Reversing Entries
|
JEs marked as auto-reversing entries post a reversing entry into the next period. Print the report by date range, period or range of periods and by account or range of accounts.
|
Media WIP Accrual Entries
|
WIP accrual entries are automatically created by the media buying system for tracking media work in progress. The accounts debited and credited, dates, and invoice numbers are reported for media accrual AP invoices and pre-billed insertion orders. They are posted by client media billings (i.e., broadcast and print media) from Accounts Receivable and the media accrual invoices from Accounts Payable. Together they properly account for media pre-billings by estimating the cost of the media. When the vendor’s final media invoice arrives, the actual media cost is reconciled with the accrual.
|
G/L Media Reconciliation
|
The Open Client-Paid Payables report shows unpaid vendor invoices that have been billed to and paid by clients. If you only pay vendors once the client has paid you, then this report is essential. Together with the Vendor Aging report, it’s how you’ll know which invoices to pay now.
|
Recurring Entries
|
JEs marked as recurring entries are reported by date range, period range and account range.
|
Adjusting Entries
|
JEs entered as Adjusting JEs to balance a transaction are listed on this report. Print the report by date, period or account.
|
Clearing Entries
|
This report lists the JEs posted from Transfer Account Balances in G/L Tools. The accounts transferred from (cleared) and the accounts transferred to are listed. Print the report by date, period, and account.
|
Pending Recurring Entries
|
TBD
|
🎯 These are some common options to use with G/L reports:
Reports can be limited to showing only JEs added by or posted by a specific staff member.
TIPS
📌 A/P reports can be printed for previous periods -- even if the period is locked -- by choosing the period from the drop-down menu.
📌 A/P reports are normally printed either to the printer or the screen. By using Print Destinations under the File menu, you can export to a spread-sheet compatible text file, print in PDF or HTML format or even e-mail your billing reports.
📌 If the user printing A/P reports doesn't have
access permissions to see costs, the invoice's gross (i.e., billable) amounts will only appear on the report.
FAQs
💬
What qualifies as "other" on some A/P reports? Reports such as the Vendor Purchases Analysis Report calculates the total amount of purchases for all vendors for the specified time frame then divides that by the toal number of vendors that had purchases in that same time frame. The result is the average per vendor. All vendors that have total purchases above the average will be listed on the report. All vendors with total purchases equal to or below the average will be included in the "Other" category.
SEE ALSO
Order Templates
Interactive Budget Alerts
PO FAQs
EXPLAINERS
Media Vendors