Finance - journals reports

The Journals (Detail) report creates the journal entries for you importing into your accounting system based on the activity in Utilmate.  It can be run at any time from the Reports menu, Finance and select Journals Report.

Filters

This report can be run for a single accounting period (month) or for a selected Xero GL Export date. You can generate it for all buildings or for an individual building, and you also have the option to show Net Movement.

Invoices, receipts, and adjustments are the only three items that impact the accounts receivable in Utilmate.  For each transaction, these are the resulting journals created.

Transaction Type	Journal Entry	Description
Receipts	DR – Bank Account CR - Debtor Master Account
Invoices	DR - Debtor Master Account CR – Sales Account CR – Tax Account	Electricity Charges Gas Charges Other Charges
Invoice Reversals	CR - Debtor Master Account DR – Sales Account DR – Tax Account	Electricity Charges Gas Charges Other Charges
Debit Adjustments	DR - Debtor Master Account CR <Adjustment Reason> CR – Tax Account	Electricity Charges Gas Charges Other Charges
Credit Adjustments	DR <Adjustment Reason> DR – Tax Account DR - Debtor Master Account

Columns

The Journals report contains the following columns:

• Account Number
• Sales Cust Number
• Account Name
• Note
• Network Node Code
• Debit/Credit
• Invoice Amount
• Invoice Date
• Transaction number
• Amount