Before you set up a new bank account, you must have a copy of your most recent bank statement. You use the ending balance
from your most recent bank statement as the starting balance of the bank account in the following programs:
Microsoft Office Accounting Professional
Microsoft Office Accounting Express
Microsoft Office Small Business Accounting 2006
Then, you enter outstanding checks, deposits,
transfers, bank fees, and interest income so that the program can handle future reconciliations.
If you are using account numbers, type the General Ledger
account number for this bank account in the Account no box.
In the Account name box, type a name
for this bank account.
In the Balance box, type the ending
balance from your most recent bank statement.
In the Cash Flow category drop-down list,
select Financing, Investing, or
Operating.
In the Bank name box, type or select
the name of your financial institution.
Note Not all financial institutions are available for online banking.
To view a list of available banks, follow these steps:
On the Banking menu, point to Banking Services, and then click Services Overview. A Web page opens.
On the Web page, click Bank Online on the left side of the page, and then click Compatible Banks.
In the Bank account type list,
click Checking, Saving, or Money
Market.
In the Bank account no box, type the
account number from the selected financial institution.
In the Comments box, type any
additional information about this account.
Click Save and Close.
When you enter a balance, your bank account
is debited (increased) and the Opening Balances system account is credited (decreased).
Enter outstanding checks
On the Banking menu, click
Account Register.
In the Bank account name box, add or click
an appropriate bank account.
On the Actions menu, click New
Transaction.
Make sure that the Write Check option is selected, and then click
OK.
Type the check number and the check date.
In the Pay to box, click the vendor, the
customer, or the employee to whom the check was written.
Type the amount of the check.
In the Items and expenses area, click the
accounts that were paid with the check or the items that were purchased with the check. The accounts that you select will be debited when the check is saved.
Note If a vendor or a customer is selected in the Pay
to box, you do not have to select anything in the Items and
expenses area. However, this behavior will affect the General Ledger. If the
check was written to a vendor and you do not select an account or an item, the
Accounts Payable account will be debited when the check is saved. If the check
was written to a customer and you do not select an account or an item, the
Accounts Receivable account will be debited when the check is saved. You must
know how this behavior will affect the General Ledger before you enter and save the
check.
Click Save and Close.
Repeat steps 3 through 9 for all outstanding checks.
Note If line items are selected in the Items and
expenses area, the total line amount must match the check amount
before you can save the check.
Enter outstanding deposits
To enter outstanding deposits, use one of the following methods.
Method 1: If you use Accounting Professional or Accounting Express
On the Banking menu, click Make Deposit.
In the Deposit in box, click the appropriate bank account.
In the Date box, select a date for the deposit.
Under the Payment received area, select Financial Account in the Type column.
In the Account column, use one of the following procedures:
Click an existing account that will offset the bank account.
Click Add a new Financial Account to add an account that will offset the bank account.
This account will be credited when the deposit is saved.
Type the amount of the deposit.
Type a memo, if applicable.
Click OK.
Repeat steps 3 through 9 for all outstanding deposits.
Method 2: If you use Small Business Accounting 2006
On the Banking menu, click
Account Register.
In the Bank account name box, click
the appropriate bank account.
On the Actions menu, click New
Transaction.
In the Select Transaction dialog box, click
Make Other Deposit, and then click OK.
Select the date of the deposit.
In the Charge to list, use one of the following procedures:
Click an existing account that will offset the bank account.
Click Add a new account to add an account that will offset the bank account.
This account will be credited
when the deposit is saved.
Type the amount of the deposit.
Type a memo, if applicable.
Click OK.
Repeat steps 3 through 9 for all outstanding deposits.
Enter outstanding transfers
On the Banking menu, click
Account Register.
In the Bank account name box, click
the appropriate bank account.
On the Actions menu, click New
Transaction.
Click Transfer Funds, and then click
OK.
Select the date of the deposit.
In the Transfer from area, select the
account name from which the funds were transferred.
In the Transfer to area, select the
account name to which the funds were transferred.
In the Transfer from area, type a memo,
if applicable.
In the Transfer to area, type the amount
of the transfer.
Click Transfer.
Repeat steps 3 through 9 for all outstanding
transfers.
Enter outstanding bank fees
On the Banking menu, click
Account Register.
In the Bank account name box, click
the appropriate bank account.
On the Actions menu, click New
Transaction.
Select Enter Bank Fee, and then click
OK.
Select the date of the bank fee.
In the Charge to list, use one of the following procedures:
Click an existing account that will offset the bank account.
Click Add a new account to add an account that will offset the bank account.
This account will be debited
when the bank fee is saved.
Type the amount of the bank fee.
Type a memo, if applicable.
Click OK.
Repeat steps 3 through 9 for all outstanding bank fees.
Enter outstanding interest income
On the Banking menu, click
Account Register.
In the Bank account name box, click
the appropriate bank account.
On the Actions menu, click New
Transaction.
Click Enter Interest Income, and then
click OK.
Select the date of the interest income
transaction.
In the Income Account list, use one of the following procedures:
Click an existing account that will offset the bank account.
Click Add a new account to add an account that will offset the bank account.
This account will be
credited when the interest income transaction is saved.
Type the amount of the interest income transaction.
Type a memo, if applicable.
Click OK.
Repeat steps 3 through 9 for all outstanding bank fees.