Movement on funds report

SUGGESTED

We're using the charity version and I'm looking for a Movement on funds report with in year/period - I would like it to show o/bal beginning of year/period, income & expenditure (separately) for period and c/bal and all fund listed separately on the one page.

Is there one or do I need to create one? Any suggestions welcome.

  • 0
    SUGGESTED

    Hi Laura,

    There are a number of reports available to use when using the charities option. The following table lists the reports we recommend to use with charities, however, the creation of new, or the amendment of existing Charity reports, is outside the Report Design boundaries, due to the complexity of the reports.  

    Report

    Description

    Location

    Balance Sheet by Funds

    Sage 50 Accounts 2011 (v17) and above.

    This report displays assets and liabilities, grouped by the chart of accounts. You can run this for all funds or for individual funds.

    Charitable funds > Balance sheet.

    Charitable funds > Reports > Charity reports.

    Sage 50 Accounts 2011 (v17) to 2014 (v20) - Financials > Funds > Balance Sheet.

    Detailed Gift Aid Donations Report

    Sage 50 Accounts 2013 (v19) and below.

    This report lists all customers who have the Customers > Record > Details tab > Gift Aid Declaration Received check box selected. This report can be used to help you complete form R68 (New Gift Aid) required by HM Revenue & Customs (HMRC).

    Note: This report isn't a replacement for form R68 and shouldn't be used to submit information to HMRC.

    Customers > Reports > Customer activity.

    Fund Analysis Report

    This report lists all transactions posted to each fund, by nominal code. For further information about this report, please refer to Ask Sage article 10285.

    Charitable funds > Reports > Charity reports.

    Financials > Reports > Charities.

    Fund Nominal Activity

    This report lists all transactions for each nominal code for the criteria specified and includes the Fund ID.

    Charitable funds > Reports > Charity reports.

    Sage 50 Accounts 2014 (v20) and below - Nominal Ledger > Reports > Nominal activity .

    Income & Expenditure (Charities)

     

    Shows the period and year to date balances of the income and expenditure nominal codes, grouped by the chart of accounts. Values are based on the nominal buckets.

    This report shows the same information as the Profit and Loss report - PNL.report, except the totals are called Gross and Net Income / (Expenditure), rather than Gross and Net Profit / (Loss).

    Charitable funds > Reports > Charity reports.

    Sage 50 Accounts 2014 (v20)and below - Financials > Reports > Profit and loss.

    Nominal List grouped By SOFA Category

    This report lists nominal codes, grouped together by the SOFA category. The SOFA category is picked up from Company > Nominal Ledger > Record > Details tab.

    Charitable funds > Reports > Charity reports.

    Sage 50 Accounts 2014 (v20) and below - Financials > Reports > Charities.

    Profit and Loss by Fund

    Sage 50 Accounts 2011 (v17) and above.

    This report shows the period and year to date balances of the profit and loss nominal codes, grouped by the chart of accounts. You can run this for all funds or for individual funds.

    Charitable funds > Profit & loss.

    Charitable funds > Reports > Charity reports.

    Sage 50 Accounts 2011 (v17) to 2014 (v20) - Financials > Funds > Profit & Loss.

    Statement of Financial Activities

    This report shows charitable income and expenditure figures, by category, broken down by fund type. The report includes category totals, income and expenditure sub totals, and overall net totals before transfers.

    Note: The SOFA report in Sage 50 Accounts isn't designed for direct submission to the Charity Commission. The information included is designed to assist with the production of the final accounts.

    Charitable funds > Reports > Charity reports.

    Sage 50 Accounts 2014 (v20) and below - Financials > Reports > Charities.

    Un-Submitted Gift Aid and Tax Repayment Claims Report

    Sage 50 Accounts 2014 (v20) and above.

    This report shows donations received but not yet submitted under the Gift Aid and Gift Aid Small Donations Schemes.

    When you print or export this report you're prompted to flag the included transactions as submitted. This prevents those transactions from appearing on the report in future.

    Charitable funds > Reports > Charity reports.

    Sage 50 Accounts 2014 (v20) - Financials > Reports > Charities.

  • 0
    Thanks Fiona, so basically I need to go back to excel for the specific report I would like.