This is what you need to know to do your first bank reconciliation, a bank transaction entry and a bank transfer in Microsoft Dynamics GP 2015.

First Bank Reconciliation:

  1. Verify that all transactions are posted into the system.
  2. Verify that all deposits have been recorded.
  3. Enter in adjusting Entry Bank Balance
    1. Balance on day company was started
    2. or last reconciled bank statement
  4. Enter in all Outstanding Checks
  5. Enter in all Outstanding Deposits
  6. Enter in ADJ Entry for all above

Banking Module Transactions in Dynamics GP (Great Plains)

2 a

Bank Deposits:

Financial Trx>>Bank Deposits

All Cash Receipts that are entered into Dynamics come into Dynamics GP but need to be deposited.

Use Financial>>Trx>>Bank Deposits to do this.

2 b

Enter/Edit

2 c

Choose:  Deposit With Receipts (Deposits that came through your system)

  • Came from Subledgers
  • Cash Receipts
  • Payments against an SOP Order

Deposit without Receipts:

You have entered into the system and it did not flow thru Banking:  Adding an entry that will not affect GL Cash Account but will affect your bank balance

Clear Unused Receipts:

You made adjusting entries thru the system already and don’t’ want them to come into your bank account.

Deposit EFT:

If you are accept EFT Payments then your EFT’s will show up here and you can deposit them separate from your Checks and Cash /Daily Deposits to match your bank.

Bank Transaction Entry

Trx>>Financial>>Bank Transaction Entry

All Miscellaneous Cash Receipts that come into GP should be entered as Bank Transactions.

Financial>>Trx>>Bank Transactions.

2 d

You can:

Enter Receipts

2 e

Any Receipt would then need to be deposited.  These would be miscellaneous checks that are not from A/R or A/P transactions. (not entered into sub-ledger)

Enter Transactions

2 f

If you have Outstanding Checks that needed to be entered into your system at the beginning, you would enter them here.

Within Bank Transactions you are able to enter in the distributions for your miscellaneous receipts or transactions.

Bank Transfers

Trx>>Financial>>Bank Transfers

If you have more than one account you can use the bank transfer method (usually used at the end of the month to transfer funds out of Bank to Money Market Fund and able to show a zero balance when reconciling).*Cannot do InterCompany at this time.

2 g

If you are interested in Dynamics GP training or support contact 860-485-0910 x3 or support@calszone.com

Get more Dynamics GP Tips and Trick www.calszone.com/tips

By Susan M. Conrod, Senior Implementation Consultant, CAL Business Solutions, www.calszone.com