End of Month Reports

Hi Community

What are the best end of month reports for financial reporting apart from PnL, BS and CashFlow. Is there one report or perhaps a modified report that captures all the data and highlighting all payments from both BS and PnL and bank balances?

Answers

  • Bruce
    Bruce Member Posts: 439 Professional Partner Professional Partner
    edited March 2023

    I am from the "cash is king" school.

    Hence, in my opinion the most valuable report I can provide clients is projected cash flows and running bank balances.

    To do this properly can require a bit of thought, particularly around the assumptions behind when receivables will be received. Also when salaries, other major expenses and tax instalments are to be paid etc. In my experience this is best done on a spreadsheet, so outside the scope of the accounting system.

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,315 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert

    @Loretta Wisdom-Zagon The beauty of RA/RAH is that you can create your own!

    From the Find filters, you can filter for specific accounts or account types, add/remove columns & sort/ subtotal as required. Once tweaked exactly how you want it, name & Memorise it for re-generation anytime 😊

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    [email protected]

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Loretta Wisdom-Zagon
    Loretta Wisdom-Zagon Member Posts: 36

    Thanks Bruce and Shaz

    Shaz having a report combining PnL items and BS items is what I'm after. I'm familiar with using filters but don't think this is a possibility or am I missing something?

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,315 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited March 2023

    Hi @Loretta Wisdom-Zagon

    You can filter for All Accounts & any other criteria.

    This produces results as per the General Ledger (a report which shows all transactions, totalled by account) The default version of this report is under the Reports dropdown menu > Accountant > General Ledger.

    The Trial Balance (in the same default Report popup menu) will also give you a summary of just the (Debit/Credit) balances for each account.

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    [email protected]

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)