Balance Sheet and Fund Balance don't match

[khoho]

Hi,

We are having trouble balancing our Savings Statements to the Balance sheet and Fund Balances. We have a set of funds (03 - 10) that make up the Savings account (1 savings account). After tranactions are posted and reports are run The amounts don't match. Example. Beginning Balance in Savings for July $3,468.55, Ending balance July $4,591.96 - total tranaaction amount is $1,123.41. The balance sheet reflects this amount as does the activity report for major account 1210, however when I take the ending balance for June on the Fund balance report for accounts 03-10 and the ending balance for July on the fund balance report they only total 1093.00.
Can you provide any suggestions as to what might be wrong?
System is XP and version of PC+ is 8.0. Not sure how long this has been going on I am just starting to try and figure this out.

Below is the activity for July
Referenc JournMonthDate Transaction Descri Debit Credit

01-1210 LNB Savings (Reg.) 783 Beginning Bal 4,987.67
FUNDS TRAN GE 0607 07/31/20 Funds Trans. to Chec 71.62
TRANSFER GE 0607 07/31/20 Trustee Trans. to Ch 11.62
TRANSFER GE 0607 07/31/20 We Care Tran to Chk. 60.00
Subtotal 71.62 71.62
LNB Savings (Reg.) 783 Current Bal 4,987.67

03-1210 LNB Savings (reg.) 783 Beginning Bal -4,252.12
CONTRIB. CO 0607 07/09/20 Contributions 03-121 54.00
TRUSTEES GE 0607 07/09/20 Rummage Sale Income 500.00
CONTRIB. CO 0607 07/16/20 Contributions 03-121 2.00
CONTRIB. CO 0607 07/23/20 Contributions 03-121 25.00
CONTRIB. CO 0607 07/30/20 Contributions 03-121 6.00
TRANSFER GE 0607 07/31/20 Trustees Trans. to C 11.62
Subtotal 587.00 11.62
LNB Savings (reg.) 783 Current Bal -3,676.74

04-1210 LNB Savings (reg.) 783 Beginning Bal -396.83
ADULT BIBL GE 0607 07/09/20 Adult Bible Study 6.00
CORRECTION GE 0607 07/09/20 Adult Bible Duplicat 6.00
EDUCATION GE 0607 07/09/20 Rummage Sale Income 500.00
FUNDS TRAN GE 0607 07/14/20 Education Tran to Sa 47.03
ADULT BIBL GE 0607 07/16/20 Adult Bible Study 4.00
ADULT BIBL GE 0607 07/23/20 Adult Bible Study 10.00
ADULT BIBL GE 0607 07/30/20 Adult Bible Study 5.00
Subtotal 572.03 6.00
LNB Savings (reg.) 783 Current Bal 169.20

08-1210 LNB Savings (reg.) 783 Beginning Bal 117.87
WE CARE GE 0607 07/02/20 We Care Income 2.00
TRANSFER GE 0607 07/31/20 We Care Tran to Chk. 60.00
Subtotal 2.00 60.00
LNB Savings (reg.) 783 Current Bal 59.87

09-1210 LNB Savings (reg.) 783 Beginning Bal 498.54
CONTRIB. CO 0607 07/02/20 Contributions 09-121 25.00
CONTRIB. CO 0607 07/16/20 Contributions 09-121 5.00
CONTRIB. CO 0607 07/30/20 Contributions 09-121 10.00
Subtotal 40.00
LNB Savings (reg.) 783 Current Bal 538.54


Total Debits & 1,272.65 149.24

The problem seems to be in funds transfer but I am not sure. Accounts 08 and 09 show net change amounts of $58 and $40 respctively correctly on the fund balance report.

[wms7328]

You may be able to find the problem with a trial balance report under fund accounting:reports. Run this report for all you funds and see if the last line that says Fund XX Totals (DB-CR) is always zero. If not, then you have some transactions that don't balance within each fund.

That sounds like your problem. If you have already tried this and it shows zero in all those totals, then I'm not sure where to tell you to look without knowing the details of how your accounting is setup.

[Matt]

The Fund Balance account will only be the same as an asset account when there is just one asset account and no liability or equity accounts other than the Fund Balance account for that accounting fund. Also, as WMS7328 mentions, the trial balance for that accounting fund must be in balance. Check to see if these conditions are true for your funds 03-10.