For reasons unknown, the foundation fund balances are often a bit off from the official foundation fun balances. To compare the database amount to the amount they’re reporting:

1. Use Microsoft Access to open the Foundation Fund Database at: I:\ACQ\AcqStatistics/FoundationAccounts.mdb

2. Click on “Main Interface.” If you don’t see “Main Interface,” use the drop-down at the top of the left panel to change to “Forms,” which is where the Main Interface is located.

3. Click “Calculate Foundation Balances.”

4. Report opens. Right click on it and select print.

5. Compare the amount on this report with the amount on the report from the foundation.

6. Note any differences, using a negative sign if database shows an amount smaller than the foundation report. You’ll use the negative sign in the database to add money. When you don’t use the negative sign, you’ll be subtracting money.

7. Close the report in the database. The main interface appears.

8. Click New Money Entry.

9. For each change you need to make,

   1. Select the fund in the fund drop-down.

   2. In the Year/Month box, enter the year month in the following format, 2011/02, and add /ADJ to the end, eg. 2017/07/ADJ.

   3. In the vendor and invoice boxes, enter “XX”

   4. In the price column of the first row, add the amount of the change you noted, including negative signs where the database showed an amount less than the foundation report to add money. Without the negative sign, you’ll be subtracting money.

   5. In the title column of the first row, enter “XX”.

   6. Click the right arrow at the bottom of the window to start another “New Money Entry,” (saving happens automatically).

   7. After all of the new spendable income is entered, close the window, and the main interface reappears.

   8. Click “Update Statuses for a Given Month”.

   9. Enter your year/month in the search box surrounded by *, eg. “2017/07/ADJ*

   10. This should retrieve a summary showing all of the adjustments that you entered.

   11. Use the drop-down in the Status column to change to the status to “Reimbursed.”

10. Repeat until all of the amounts match.