The General Ledger report summarizes your facility’s financial transactions in a simple debit/credit format. It provides you with the net total by account code for the date range chosen. This allows you to easily make a single journal entry to transfer your storEDGE financial transactions to your accounting software. It can be customized to use your account descriptions and your account codes. Additionally, if you use any of these accounting programs, the General Ledger report can be exported out of storEDGE in their required format for easy import into those programs:

• AMSI
• Appfolio
• Great Plains
• Quickbooks (both the desktop and online versions)
• Sage 300 (formerly known as Timberline)
• Entrata
• Microsoft Dynamics
• *Acumatica - this option is not available to select when exporting the report, but is available as an integration. 
• Yardi

To export the data, just select your accounting software from the dropdown when generating the report. The file that is exported can be imported directly into your accounting software.

⚠ If you are using Sage 300 (Timberline), you’ll need to ensure that a store number is entered into your Facility Info. This populates into the exported general ledger data and is needed for your data to be assigned to the right facility in Sage. You can learn more about adding a store number into your facility info on our help site.

General Ledger Report for Cash Accounting

Cash Accounting is the process by which revenue is recognized when money is exchanged. For facilities using the Cash Accounting method, you’ll have a General Ledger report similar to the one above.

Whenever a payment is made, this report will reflect a debit to the cash asset account used in the transaction and a credit to the income (or liability account in the case of tax or security deposits) account used in the transaction. Whenever a refund, voided payment or payment reversal is processed, this report will reflect a credit to the cash asset account used in the transaction and a debit to the income (or liability account in the case of tax or security deposits) account used in the transaction.

In Cash Accounting, there are no general ledger transactions recorded for generated  invoices, credits, bad debt write offs, or waived fees. The only time a general ledger transaction is recorded is when money exchanges hands via a payment, refund, or payment reversal.

⚠ In storEDGE, discounts are written to the general ledger as a reduction of income rather than written as the full income amount less discount expense. For Cash Accounting that means if you charge a tenant $100 for rent but give them a $10 discount resulting in a $90 payment, when the payment is processed you will see that written in the General Ledger report as a debit of $90 to the appropriate cash asset account and a credit of $90 to the Rental Revenue account.

General Ledger Report for Accrual Accounting

Accrual Accounting is the process by which revenue is recognized when it is incurred, regardless of when money is exchanged. For facilities using the Accrual Accounting method, you’ll have a General Ledger report similar to the one above.

Whenever any financial transaction is processed in storEDGE, it will be reflected on the General Ledger report. For example, on the day an invoice is due for $100 worth of rent, the General Ledger report will show a $100 debit to Accounts Receivable - Rent and a $100 credit to Rental Revenue. When that invoice is paid, the General Ledger report will show a $100 debit to the appropriate cash asset account and a $100 credit to Accounts Receivable - Rent.

⚠ In storEDGE, discounts are written to the general ledger as a reduction of income rather than written as the full income amount less discount expense. For Accrual Accounting that means if you charge a tenant $100 for rent but give them a $10 discount resulting in a $90 payment, when the invoice is due, you will see a $90 debit to Accounts Receivable - Rent and a $90 credit to Rental Revenue. When that invoice is paid, the General Ledger report will show a $90 debit to the appropriate cash asset account and a $90 credit to Accounts Receivable - Rent.

⚠ Since the General Ledger reports the net of all transactions for a date range and the General Ledger Detail reports the full transaction for a date range, the total debits and credits on the reports will not match. This example illustrates that point.
Tenant A pays $50 for rent and Tenant B is invoiced $85 for rent but doesn’t pay it. 

Adding Custom Descriptions and Account Codes to the General Ledger Report

The General Ledger report can be customized to use your account descriptions and your account codes. Navigate to Corporate Settings in your account and select the Account Codes button in the Software Settings tab. There you can change the default account description and add your company’s account codes to the chart of accounts.