If you know the transaction’s reference number (i.e., invoice number, check number, etc.) you can find its JEs easily.
1️⃣ Enter the JE's reference number (e.g., AR#19028) then click the 🔍 button.
Unlike finding invoices or checks, you’ll need to include the reference number’s prefix when finding G/L entries: AP# (Accounts Payable), AR# (Accounts Receivable), CK# (the Checkbook), PMT# (Client Payments), WIP#(Media Accruals), or EXP#(Employee Expense Reports). The prefix tells Clients & Profits which part of the system posted the entries. General journal entries usually begin with JE#, but it depends on how staffers typed them in.
Sometimes you may be looking for a $150 entry, but don’t know its reference number. Power Search makes it easy.
1️⃣ Click the Power Search link.
2️⃣ Choose a search for field from the dropdown menu, then choose the kind of search (i.e., is, contains, begins with) and enter a value (i.e., name, number, date, etc.). Click the ➡️ button to save this search criteria.
Repeat these steps to expand your search to include other fields and other search values.
3️⃣ If you're ready to run the power search, click the 🔍 button.
.
Clients & Profits will display the results in the table. You can click on a column heading to sort the results.
📌 You can save frequently-used power searches by naming a search then clicking the memorize (➕) button. You'll see all of your saved searches in the memorized searches dropdown menu.
General journal entries can be added any time during the month for payroll, insurance expenses, bank fees, etc. That is, anything that doesn't involve Accounts Payable, Accounts Receivable, Client Payments, Checkbook, or employee expense reports
1️⃣ Click the Add toolbar button.
2️⃣ Enter the transaction's debits and credits and description.
3️⃣ Click Save, then proof & post.
Click here for step-by-step instructions.
Cloning makes an exact duplicate of an existing transaction's debit and credit journal entries. You can clone any general journal entry, even from previous periods. JEs for other journals can't be cloned.
1️⃣ Find (or click on) the transaction you wish to clone, then click the Clone toolbar button.
2️⃣ Make any changes you need to the cloned JE's debits and credits, as well as description.
The Add Journal Entries window opens, displaying the newly-cloned transaction. The new entry has today’s date, the current period, and the next automatic reference number (copied from your accounting preferences). But the description and debit and credit journal entries are identical to the original transaction.
3️⃣ Click Save.
Once saved, the cloned entry can be proofed and posted like any other entry.
The Edit G/L Amounts window lists the transaction's debit and credit journal entries. You can edit these amounts by simply typing in the new amounts over the old ones. The total debits must equal the total credits or else your changes won't be saved.
1️⃣ Find (or click on) the transaction you need to change, then click the Edit toolbar button.
The Edit Journal Entry window opens, displaying the entry’s G/L account, period, date, description, job, client, vendor, and debit or credit amount. If the journal entry is posted, only the description can be changed. To prevent unbalanced entries, an entry’s accounting period and date, can’t be changed -- whether or not the entry has been posted. The entry’s account number, reference number, description, client number, job number, and vendor number can be changed.
2️⃣ Make any changes you need to the transaction's debits and credits, as well as description.
3️⃣ Click Save, then proof & post.
Click here for step-by-step instructions.
Only unposted journal entries can be deleted. (Once a journal entry is posted, it can't be deleted -- however, adjusting entries can be made to reverse it or it can be unposted.) Journal entries are deleted by transaction, not by individual entry, to prevent unbalanced entries.
1️⃣ Find (or click on) the transaction you want to delete, then click on the Delete toolbar button.
📌 To delete all unposted journal entries, including any upcoming recurring entries, choose Edit > Delete All Unposted JEs.
General journal entries have to be posted before they upload financial statements. Once posted, JEs can't be deleted. A proof list can be printed to review your new JEs for errors prior to posting.
1️⃣ Click on the
Proof/Post toolbar button then follow the prompts.
Click here for step-by-step instructions.
Clip notes can be added to document something about a journal entry. Anyone with access to the General Ledger can see your clip notes, and different staffers can add their own clip notes to the same JE.
1️⃣ Find (or click on) the transaction that needs the clip note, then click on the
Clip Note toolbar button.
2️⃣ Enter the JE's note, then click Save.
If a JE has a clip note, you'll see a number in the Clip Note toolbar button. Click on the button to read (or edit) the notes.
Journals, audit trails, and accrual reports can be printed for the fiscal year's journal entries. The Print Reports window has options to select entries by various dates, accounting periods, a range of G/L accounts, and for specific journals.
1️⃣ Click on the
Print Reports toolbar button.
Clients can be found in several ways: by account number; by organization name; by cost center; by sequence; or, by browsing through the Clients file.
2️⃣ Choose your report selections and options, then click Print.
If a JE has a clip note, you'll see a number in the Clip Note toolbar button. Click on the button to read (or edit) the notes.
Click here for step-by-step instructions.
The Auditor performs automatic self-checks on your Accounts Payable, Accounts Receivable, and General Ledger totals. It’s used for troubleshooting data entry and posting problems. Because it automatically double-checks account totals against the records that make them up (e.g., G/L account balances and their journal entries), it saves users from having to print and analyze hundreds of pages of reports to find accounting problems.
How the Auditor works: The Auditor works by double-checking the records in your A/P, A/R, and G/L data files. The complete auditing process includes checking for out-of-balance G/L entries, making sure that the A/P and A/R agings equal the Balance Sheet totals, and ensuring that billable time entries contain a client number. Each auditing step has a different function
1️⃣ Click on the
G/L Tools toolbar button and choose
Auditor.
Click here for step-by-step instructions.
📌 All of the Auditor’s steps can be performed at the same time, or individual steps can be chosen to run independently. If time allows, all of the steps can be run together; however, if you suspect a specific problem that the Auditor can confirm and time is tight, you can choose to run only one step at a time.
📌 Everyone can keep working in Clients & Profits while the Auditor is working, and it can be canceled any time without damaging the database. The Auditor can be run any time during the month, and as frequently as needed.
📌 Also, don’t mistake the Auditor for a traditional accountant-based financial audit. The Auditor can only check the account totals themselves, ensuring that they add up correctly. It can’t make value judgment about how users have entered data (for example, it can point out that the wrong expense account was used). It doesn’t replace a professional accounting audit. Instead, it is only a useful tool for finding the source of accounting problems.
A G/L account number can't be changed once it has a balance. So what happens when you decide to reorganize your chart of accounts? One option is to wait until the year is closed, when all of the income, cost, and expense accounts are zeroed out. But what about asset, liability, and equity accounts that always keep their balances? That's when you'd use the Transfer Account Balances tool. It lets you move an account's balance to another account. It happens automatically, which simplifies the process and keeps it more accurate.
1️⃣ Click on the
G/L Tools toolbar button and choose
Transfer Account Balance.
2️⃣ In the Transfer Account Balances window, enter the from G/L account and the to G/L account.
3️⃣ Choose a range of accounting periods from the two dropdown menus, then click 🆗.
Clients & Profits will then add journals entries to move the account balances between the selected accounts, establishing the audit trail to document the transaction.
The task of auditing prepaid and accrual accounts is simplified with the G/L Reconciliation. It lists an account's entries from the General Ledger. The entries are then marked as cleared. Once saved, the cleared items will be removed from the reconciliation window. A G/L reconciliation report can be printed to prove your Balance Sheet account balances.
1️⃣ Click on the
G/L Tools toolbar button and choose
G/L Reconciliation.
Click here for step-by-step instructions.
If a technical issue disrupted a posting, you can manually add an adjusting entry to the out-of-balance transaction to fix it. This tool is used rarely, if ever, and only to fix errors in your accounting data that occur during posting. It allows you to add a debit or credit journal entry, but without its balancing journal entry.
1️⃣ From the General Ledger window, click on the transaction that needs an adjusting entry.
2️⃣ Choose Edit > G/L Tools > Add Adjusting JE.
3️⃣ Enter the adjusting journal entry’s G/L account number.
If you don't know the number, press Tab to open the Lookup List. Be sure that this is the correct account number -- the one that wasn’t updated originally during posting. If you enter the wrong account number, you’ll be updating the wrong account -- and your financial statements will likely be worse than before you made the adjusting entry.
4️⃣ Enter the adjusting JE’s account period and date.
This should be the same accounting period as the original transaction.
5️⃣ Enter the adjusting JE’s description then an (optional) job number, client, and vendor.
6️⃣ Enter the adjusting journal entry’s debit or credit amount.
This must be the amount for which the original transaction is out of balance. If not, the transaction will still not be in balance.
7️⃣ Click
Save.
This entry should now appear with the other entries in the original transaction, which should now balance; if not, the adjusting entry should be deleted and re-entered.
This adjusting journal entry is saved, but not posted. It must be posted before it updates your financial statements. Only unposted entries in a transaction will be posted. This means only your adjusting entry will be posted; the transaction’s other journal entries won’t be posted twice.
If you produce your own payroll checks using the CheckMark Payroll software, payroll data can be imported into Clients & Profits. CheckMark has the ability to export payroll information into a standard text file. Clients & Profits then imports this text file into the General Ledger as an unposted payroll journal entries. For more information on CheckMark Payroll, contact CheckMark at www.checkmark.com
1️⃣ Click on the G/L Tools toolbar button and choose Import Payroll....
2️⃣ In the Transfer Account Balances window, enter the from G/L account and the to G/L account.
3️⃣ Click Save.
You can find clients by organization name, cost center, or by sequence (i.e., the order in which clients were added). Click the previous and next buttons to browse clients sequentially. You can alternately view a client by choosing it from the Show drop-down menu.
This tool calculates each client's share of the agency's overhead expenses for any selected month. The overhead allocation worksheet adds up the hours worked by each staff member, then allocates a proportion of the overhead expenses to each client based upon the specific method.
The worksheet lets you enter the month's payroll totals for each employee, which then become part of the client's overhead allocation. The client overhead totals are then used on the Client P&L Analysis report.
1️⃣ Click on the
G/L Tools toolbar button and choose
Overhead Allocation Worksheet..
Click here for step-by-step instructions.
Clients & Profits can handle two open fiscal years, for a total of 24 accounting periods. So while there's no real urgency to close the first year, at some point it's necessary. Year-end closing is very easy and mostly automatic. Clients & Profits handles everything.
Once you've entered the year's remaining entries, you'll run the Close Year procedure. It presents a checklist of steps it goes through to close out the fiscal year. Once you've started the close year process, it runs unattended until it finishes. Afterwards, you can print a log of steps completed by the Close Year tool.
1️⃣ Click on the
G/L Tools toolbar button and choose
Close Year.
Click here for step-by-step instructions.