The new Accounting Ledger report in webCemeteries is designed to help streamline your financial reconciliation process and seamlessly integrate your cemetery's data with accounting software such as QuickBooks.
This report provides a clear, exportable ledger of your transactions, enabling you or your accounting team to easily track revenue, payments, credits, and more. All while maintaining alignment with your General Ledger (GL) codes.
Accessing the report
Step 1
Click "Reports" from the left side menu.
Step 2
Under "Financial", select "Accounting Ledger"
📊 What Does the Report Include?
Each line in the Accounting Ledger report represents a financial event related to a signed contract or transaction, and includes the following information:
-
Cemetery Name – So you can distinguish transactions by Cemetery.
-
Item Description – Clear labeling of what was sold or transacted.
-
General Ledger (GL) Code – Mapped directly from your price catalog or your Accounting Settings.
-
Amount – The dollar value of the item, payment, credit, or adjustment.
-
Date – When the transaction or event occurred.
Tip
It's recommended you setup your default GL Codes and Adjustments by going to the Accounting Settings for accurate reporting. To enter the GL Codes for your line items, go to the Price Catalog.
🧾 How the Report Handles Financial Activity
The report accounts for a variety of contract and payment scenarios, making it a powerful tool for accurate and transparent financial reporting:
-
Signed Contracts: The total amount of a signed contract is recorded with the Accounts Receivable (A/R) GL code.
-
Payments: Payments reduce the A/R and are recorded using the Cash GL code, ensuring a proper balance between income and receivables.
-
Credits: Any credit issued to a contract will use the GL code assigned to that specific credit item, offering detailed categorization.
-
Interest Not Accrued: If a customer pays off their contract early and interest is waived, the amount is recorded using the Interest GL code for proper adjustment tracking.
-
Cancelled Contracts: If a contract is cancelled with an unpaid balance, the amount is recorded using the GL code entered at the time of cancellation, preserving the financial trail.
✅ Benefits for Accountants
-
Quick Reconciliation: Easily match transactions against your accounting software entries.
-
GL Accuracy: Every line item includes the appropriate GL code, reducing errors in manual entry or misclassification.
-
Full Transparency: Provides a clear audit trail for signed contracts, payments, credits, and adjustments.
-
Time-Saving Exports: Export the report as a CSV or Excel file for direct upload or import into QuickBooks or your preferred accounting platform.
🔄 Keeping Your Ledger in Sync
To make the most of this report:
-
Ensure your Price Catalog items are assigned to the correct GL codes.
-
Use the appropriate Adjustment GL code when voiding contracts.
-
Enter credits and interest carefully with the appropriate adjustments.
If you have questions about how to access the Accounting Ledger report, or how to configure your system for better accounting integration, please contact support—we’re here to help.