The General Ledger report lists the individual accounting entries Sharper has posted — every debit and credit, the account it landed in, the document that produced it, and the customer it relates to. It is the report that connects an operational transaction back to the accounting behind it.
This article assumes you already know the basics of the Sharper reporting module — the Name, Token, Subtotal, column picker, and filter fields. For a full walkthrough of the reporting form itself, see the Sharper Reporting Reference Guide. For how the general ledger works in Sharper, see Accounting - General Ledger. This article only covers the report.
Why This Report Matters
When a figure in your accounting system looks wrong, the question is always "which transactions make up this number?" — and this is the report that answers it. Because every row carries both the accounting detail and the operational detail that produced it, you can work backwards from a general ledger balance to the actual booking or sale. Use it to:
Reconcile an account balance by listing every entry that contributed to it
Trace an unexpected posting back to the product, customer, and staff member behind it
Check that revenue is landing in the accounts you intend before a period close
Confirm which entries have been exported to your accounting system and which have not
Reading Debits and Credits
The report gives you several ways to look at the same amount, and choosing the wrong one is the most common source of confusion:
Column | What It Gives You |
Is Debit | Whether the entry is a debit or a credit |
Amount | The entry's value, without regard to direction |
Debit Amount, Credit Amount | The value split into two columns, so debits and credits can be subtotalled separately. This is the pair to use for a conventional ledger layout. |
Net Amount | The value with direction applied, so a column of entries can be summed to a net movement |
Do not subtotal Amount across a mix of debits and credits — because it ignores direction, the total will be the sum of everything's absolute value rather than a balance, and it will look far too large. Use Net Amount for a balance, or Debit Amount and Credit Amount side by side for a ledger that proves out.
Building a General Ledger Report
Go to Reports → Accounting → General Ledger in the left sidebar.
If a shipped report is close to what you need, use the ⋯ menu → Copy first — shipped reports can only be edited by the Sharper team.
Otherwise click + New and give it a Name, such as "Month End Ledger Detail."
Add the columns below from the Available panel.
Set Subtotal to Debit Amount or Credit Amount depending on the layout you want.
Turn on All Outlets if you are closing the books across every location together.
Click Save, then Get Report to set your date range and run it.
Recommended Columns
Field | What It Shows |
Transaction Date | The accounting date of the entry — the date that determines which period it belongs to |
Created Date | When the entry was actually recorded in Sharper. It can differ from the transaction date on a backdated posting. |
Account Name, Account Number | The general ledger account the entry posted to |
Account Type, Account Description | The account's classification — useful for grouping revenue, liability, and asset movements separately |
Document Type, Document, Document Num | What produced the entry — an invoice, payment, refund, or journal — and its reference |
Ledger Num | The ledger reference for the entry |
Memo | The description carried on the entry |
Is Debit, Debit Amount, Credit Amount, Net Amount | The value columns described above |
Is Exported | Whether the entry has been sent to your external accounting system. Filter on No to find postings that have not yet transferred. |
Customer Name, Cust Email | The customer the entry relates to, where there is one |
Product Name, Product SKU, Product Tax Code, Product Taxable | The product behind the entry and how it is taxed — the place to look when revenue lands in an unexpected account |
User Display Name, User Email | The staff member whose action created the entry |
Reservation ID, Booking ID | The reservation behind the entry, where it came from a stay |
Note: Filter on Transaction Date rather than Created Date when you are reporting a period. A backdated entry posted in October against a September transaction date belongs in September's figures, and filtering on the created date will put it in the wrong month.
Useful Filters
A single account's activity: Field Account Number, set to the account, with a date range on the run screen.
Entries not yet exported: Field Is Exported, set to No.
Revenue accounts only: Field Account Type, set to your income type.
Everything from one invoice: Field Document Num, set to the invoice number.
One customer's postings: Field Customer Name, set to the customer.
Backdated entries: compare Transaction Date and Created Date over the same period to see what was posted into a closed month.
A saved report grouped by Account Number with Debit Amount and Credit Amount subtotalled is the closest thing to a conventional trial balance detail, and is the most useful single view for a period close.