Expenses and Payouts - Method K:Bank Deposits

Version 4 V4 Tutorial
1

Here is a quick tutorial continuation for a method of accounting.

This method works best to track money taken from the cash drawer nightly to be deposited to the bank. The picture below shows a deposit of 100% of the drawer you can however leave money in the drawer and it will show in the cash Balance.

Can also setup Credit account to deposit as well however I would advise doing the deposit only after you know how much the credit processor actually deposited. I will explain in a later tutorial how to make it calculate the service fees.

A basic look at the flow of how it works:

Before Transaction:

373a29d581a42e63.png1918Ă—1078 132 KB

After Transaction:

740d344fb0031e83.png1918Ă—1080 137 KB

Bank Deposit Account Screen View:

7b8b65d29f97097d.png1919Ă—1078 55.6 KB

Create Account Type:

d2924cb9be9f5c99.png795Ă—320

Create the Accounts:

Create the Account Screens:

19ff19bac4305724.png874Ă—562

Create the Transaction Types:

Optional Credit Type if you want to track it as well:

Create the Document Types:

4c9417d1e179993e.png875Ă—564

Batch Create Screen:

da050bb2ba5e3744.png890Ă—330

To show how it interacts with expenses here is a quick look at a Supplier Payout Transaction:

710571e4c7e9a613.png1913Ă—1079

If using multiple Bank Accounts assuming you Mapped each one to the Batch Create screen as mentioned above:

To select other accounts:

2fb57545bad72fee.png1041Ă—413

Result:

2a09eee066a1a6df.png1918Ă—1079

2 Likes
9

question sir… what is WK? at the date description…

exp: July/2014:WK-31

10

Week… Check Description Template setting of Bank Deposit document type to understand how it formatted.

11

Hi EMere, @Wisefix’
Here in kenya we use Mpesa as a form of payment.I have been able to incorporate the Mpesa payment method beneath the cash button and am also able to see the amount paid via Mpesa and cash in the reports.
I would like assistance on a situation whereby the user is prompted to input the Mpesa transaction code and this code to appear in receipt…I have tried to follow or discount tutorial on discount reason but I son know where an failing to synchronise the flow of the rules…kindly assist.

12

@samuelwanjiru you need to practise a lot it Seems: I have implemented Mpesa the same way the tutorial for visa card and master card were set up

13

I may be outdated, but did you just turn Sambapos into an accounting software?! frikken awesome!

14

A very simplified one but yes. You could take it further and automate it even more.

1 Like