That's it. Create WIX once and forever, and then, each month, create two new transactions in WIX. All that's left to do is post your total deposit amount into your Commerce check book, and any furlough fund activity (interest, for example) into your Quicken Furlough Fund account, and all BBFI-Missions Office-related posting should be done!

If you use Connie, your deposit amount, and furlough fund interest amount are on the Excel spreadsheet created each month by Connie using the Post BBFI Receipts function (Item 2 on Connie's main menu). Otherwise, you'll have to dig through the BBFI monthly report to find and total the figures.

The purpose of this page is to show one way of updating Quicken with month-end transactions from your BBFI monthly report (received from the M.O.). If you already have a procedure for doing this, then this page may not be helpful to you (unless you feel the procedure used here is easier).

Setup Quicken's WIX account

1.0 Create the WIX account (once-only)

Note: Koinonia's nickname "Connie" will be used throughout this documentation

(Screen shots are from Quicken 2004 Basic)

1.1 Create the account

Click on Tools, then click on Account List

Click on Add Account

Tick "This account is not held at a financial institution" radio button, and then click Next

Tick the

"Cash" radio button, and then click Next

Key in "WIX", and then click Next

Key the "As of Date" as 1/1/1981 , and then click Done.

You have now set up the WIX account once and forever.

Now to explain why we've done it

The WIX account will be used for two purposes:

1. To update Income categories (mainly NCS Work Support_03) with the total of your deductions (such as health insurance, mission office gifts, etc.). The total is provided on an Excel spreadsheet (see below) created by Connie when you use her to post receipts from the MO (Item 2 on Connie's main menu).

2. To update the various Expense categories which reflect your deductions taken by the MO (such as XPS Medical Insurance_19, XPS Retirement Fund_24, etc.)

In the above example, the figure in black highlight ($2,037.14) you would post into WIX as a receipt using category NCS Work Support_03. See below.

The screenshot above shows both transactions for the month of October, 2004. Each month, you would enter two transactions into WIX like those above. WIX should always carry a zero balance after you enter the two monthly tranactions.

The next screenshots will show WIX split lines for the Expense transaction listed above.

Note: These two WIX transactions remain mostly the same from month-to-month. Usually (for us), I Quick-fill the previous month's transactions, and change the amounts. Postage is usually the only varying amount.

In Quicken, be sure the quick-fill preferences are turned on. That way, when you create the WIX transactions for the next month, as you begin to key in "Income" or "Expense" in the Payee field, Quicken will pull in last month's transaction. Then make any changes necessary for the current month, and you're done. This is how your preferences should be set to do this:

To see your Quick Fill preferences, Click on Edit, then Preferences, then Quicken Program, then Quick Fill. Tick every box, then click on OK

2.0 Using the WIX account (once per month)

Below is a screenshot of WIX showing the November, 2004 Income and Expense transactions. The only thing that changed was the postage amount as shown in the second screenshot below