Difference between revisions of "FrontAccounting-2.4.7/C2/Taxes-and-Bank-Account-in-FrontAccounting/English"

From Script | Spoken-Tutorial
Jump to: navigation, search
(Created page with "'''Taxes and Bank Accounts in Frontaccounting ''' {| style="border-spacing:0;" | style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;paddi...")
 
 
Line 54: Line 54:
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| To practise this tutorial, you must have knowledge of:  
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| To practise this tutorial, you must have knowledge of:  
  
* Higher secondary commerce and accounting  
+
* Higher secondary commerce and accounting and
 
+
and
+
 
+
 
* Principles of Bookkeeping
 
* Principles of Bookkeeping
 
|-
 
|-
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| You should have already
+
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| You should have already  
 +
*Set up an '''Organisation/Company''' in '''FrontAccounting'''.
  
* Set up an '''Organisation/Company''' in '''FrontAccounting'''
+
*If not, for relevant '''FrontAccounting''' tutorials please visit [http://spoken-tutorial.org/ https://spoken-tutorial.org]
 
+
If not, for relevant '''FrontAccounting''' tutorials please visit [http://spoken-tutorial.org/ https://spoken-tutorial.org]
+
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| And you should have already set up an '''Organisation or Company''' in '''FrontAccounting'''.
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| And you should have already set up an '''Organisation or Company''' in '''FrontAccounting'''.
  
Line 81: Line 77:
 
|-
 
|-
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on browser >>localhost/account >> Press Enter  
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on browser >>localhost/account >> Press Enter  
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Open a web '''browser''', type''' localhost/account '''and press Enter.  
+
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Open a web '''browser'''.
 +
 
 +
Type''' localhost/account '''and press '''Enter'''.  
  
 
|-
 
|-
Line 89: Line 87:
 
|-
 
|-
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Enter Username = admin and Password = spoken>> Click on login  
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Enter Username = admin and Password = spoken>> Click on login  
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Type the '''username''' as '''admin''' and the password.  
+
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Type the '''username''' as '''admin''' and the '''password'''.  
  
 
Then click on '''Login''' button.  
 
Then click on '''Login''' button.  
Line 101: Line 99:
 
In the '''Company Setup''' panel, click on '''Taxes''' link.
 
In the '''Company Setup''' panel, click on '''Taxes''' link.
  
We can see a default entry as '''Tax'''.
+
We can see a default '''entry''' as '''Tax'''.
  
 
|-
 
|-
Line 107: Line 105:
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| The '''Percentage''', '''Sales GL Account''' and '''Purchasing GL Account''' are specified as shown here.
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| The '''Percentage''', '''Sales GL Account''' and '''Purchasing GL Account''' are specified as shown here.
  
We have to assign '''GL accounts''' to every tax used by our business.  
+
We have to assign '''GL accounts''' to every '''tax''' used by our business.  
  
 
|-
 
|-
Line 115: Line 113:
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| At the top of the window, we can see a message.
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| At the top of the window, we can see a message.
  
It is recommended that a separate '''Sale and purchase GL account''' has to be assigned to each tax.
+
It is recommended that a separate '''Sale and purchase GL account''' has to be assigned to each '''tax'''.
  
 
|-
 
|-
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| narration
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| narration
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Let us see how to add '''GST''' and '''Service tax''' for our company.
+
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Let us see how to add '''GST''' and '''Service tax''' for our '''company'''.
  
 
|-
 
|-
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on the Edit icon of '''Tax.'''
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on the Edit icon of '''Tax.'''
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on the '''Edit''' icon on the default entry '''Tax '''row'''.'''
+
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on the '''Edit''' icon on the default '''entry Tax '''row.
  
 
|-
 
|-
Line 130: Line 128:
 
Click on the Update button.
 
Click on the Update button.
  
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| I’ll edit '''Tax''' to '''GST''' , as our company will not use the default entry '''Tax'''.
+
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| I’ll edit '''Tax''' to '''GST''' , as our '''company''' will not use the default '''entry Tax'''.
 +
 
  
 
I’ll change the description to '''GST''' and the percentage to '''12. '''
 
I’ll change the description to '''GST''' and the percentage to '''12. '''
 +
  
 
I will keep the '''Sales GL account''' and '''Purchase GL Account '''as '''Sales tax.'''
 
I will keep the '''Sales GL account''' and '''Purchase GL Account '''as '''Sales tax.'''
 +
  
 
Click on the '''Update''' button at the bottom of the window.
 
Click on the '''Update''' button at the bottom of the window.
Line 144: Line 145:
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Now let us add '''Service tax.'''
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Now let us add '''Service tax.'''
  
Before that we have to create a '''GL Accoun'''t for''' Service tax'''.
+
Before that we have to create a '''GL Account''' for''' Service tax'''.
  
 
|-
 
|-
Line 150: Line 151:
  
 
Click on '''GL accounts '''
 
Click on '''GL accounts '''
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click on '''Banking and General Ledger '''tab'''.'''
+
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click on '''Banking and General Ledger '''tab.
  
 
In the '''Maintenance''' panel, click on '''GL Accounts''' link.
 
In the '''Maintenance''' panel, click on '''GL Accounts''' link.
Line 166: Line 167:
 
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Type the values as shown:
 
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Type the values as shown:
  
Then click on the '''Add''' '''Account''' button at the bottom of the window.
+
Then click on the '''Add Account''' button at the bottom of the window.
  
 
|-
 
|-
Line 182: Line 183:
  
 
'''Default Rate''': 7
 
'''Default Rate''': 7
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Type the values as shown:
+
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Type the values as shown.
  
 
|-
 
|-
Line 196: Line 197:
  
 
Click on '''Add new''' button
 
Click on '''Add new''' button
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Likewise, select''' Service Tax for Purchase GL Account.'''
+
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Likewise, select''' Service Tax''' for '''Purchase GL Account.'''
  
 
Click on '''Add new''' button at the bottom of the window.
 
Click on '''Add new''' button at the bottom of the window.
Line 210: Line 211:
 
|-
 
|-
 
| style="border-top:0.75pt solid #000000;border-bottom:1pt solid #000000;border-left:1pt solid #000000;border-right:0.75pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| narration
 
| style="border-top:0.75pt solid #000000;border-bottom:1pt solid #000000;border-left:1pt solid #000000;border-right:0.75pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| narration
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| We will first set up a '''Bank Account''' for the company.
+
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| We will first set up a '''Bank Account''' for the '''company'''.
  
 
|-
 
|-
Line 216: Line 217:
  
 
Click''' '''on''' Bank Accounts'''
 
Click''' '''on''' Bank Accounts'''
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click on '''Banking and General ledger '''tab'''.'''
+
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click on '''Banking and General ledger '''tab.
  
In the '''Maintenance''' Panel, click on '''Bank Accounts''' link.
+
In the '''Maintenance''' panel, click on '''Bank Accounts''' link.
  
This option is used to setup and configure the '''bank '''and''' cash accounts.'''
+
This option is used to '''setup''' and configure the '''bank '''and''' cash accounts.'''
  
 
|-
 
|-
Line 251: Line 252:
 
| style="border-top:1pt solid #000000;border-bottom:1pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Then update the changes by clicking on the '''Update '''button at the bottom.
 
| style="border-top:1pt solid #000000;border-bottom:1pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Then update the changes by clicking on the '''Update '''button at the bottom.
  
Likewise, change the''' Petty Cash account''' also to '''Indian Rupees''' and update the changes.
+
Likewise, change the''' Petty Cash account''' also to '''Indian Rupees'''.
 +
 
 +
And update the changes.
  
 
|-
 
|-
 
| style="border-top:0.75pt solid #000000;border-bottom:1pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Narration
 
| style="border-top:0.75pt solid #000000;border-bottom:1pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Narration
| style="background-color:#ffffff;border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Next let us add some amount to the '''ST Company pvt. Ltd. bank account.'''
+
| style="background-color:#ffffff;border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Next let us add some amount to the '''ST Company Pvt. Ltd. bank account.'''
  
 
|-
 
|-
Line 261: Line 264:
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Go to '''Banking and General ledger '''tab.
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Go to '''Banking and General ledger '''tab.
  
In the '''Transactions''' panel, click''' '''on''' Deposits '''link'''.'''
+
In the '''Transactions''' panel, click on''' Deposits '''link.
  
 
|-
 
|-
Line 280: Line 283:
  
 
Click on '''Add item'''
 
Click on '''Add item'''
| style="border-top:0.75pt solid #000000;border-bottom:1pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Keep the '''From''' field as M'''iscellaneous'''.
+
| style="border-top:0.75pt solid #000000;border-bottom:1pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Keep the '''From''' field as '''Miscellaneous'''.
  
 
I’ll enter the name of the person who has deposited the money as shown.
 
I’ll enter the name of the person who has deposited the money as shown.
Line 294: Line 297:
 
|-
 
|-
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on '''Process deposit'''
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on '''Process deposit'''
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on '''Process deposit '''button at the bottom of the window.
+
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on '''Process Deposit '''button at the bottom of the window.
  
 
|-
 
|-
Line 306: Line 309:
 
|-
 
|-
 
| style="border-top:1pt solid #000000;border-bottom:1pt solid #000000;border-left:1pt solid #000000;border-right:0.75pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Point to the amount
 
| style="border-top:1pt solid #000000;border-bottom:1pt solid #000000;border-left:1pt solid #000000;border-right:0.75pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Point to the amount
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| A pop up window appears with the transaction details of the amount that has been deposited.
+
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| A pop up window appears with the transaction details of the amount that has been '''deposited'''.
  
 
|-
 
|-
Line 314: Line 317:
 
|-
 
|-
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Point to the next link '''Enter another Deposit'''
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Point to the next link '''Enter another Deposit'''
| style="border-top:0.75pt solid #000000;border-bottom:0.75pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| If you want to enter another '''deposit, '''then click on '''“Enter another Deposit'''” link.
+
| style="border-top:0.75pt solid #000000;border-bottom:0.75pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| If you want to enter another '''deposit, '''then click on '''“Enter Another Deposit'''” link.
  
 
|-
 
|-
Line 326: Line 329:
 
|-
 
|-
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on '''Banking and General ledger>>Bank Account Transfers'''
 
| style="border:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on '''Banking and General ledger>>Bank Account Transfers'''
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| In the '''Transactions''' panel, click on '''Bank Account Transfers '''link'''.'''
+
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| In the '''Transactions''' panel, click on '''Bank Account Transfers '''link.
  
 
|-
 
|-
Line 332: Line 335:
 
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Notice that the '''Bank Balance '''is shown here as three lakh rupees.
 
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Notice that the '''Bank Balance '''is shown here as three lakh rupees.
  
Recall, this amount had been deposited earlier.
+
Recall, this amount had been '''deposited''' earlier.
  
 
|-
 
|-
Line 340: Line 343:
  
 
Memo : Money transferred for petty cash
 
Memo : Money transferred for petty cash
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| In the '''To account''' filed, select '''Petty Cash account.'''
+
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| In the '''To Account''' field, select '''Petty Cash account.'''
  
 
In the '''Amount '''field''', enter 20,000.'''
 
In the '''Amount '''field''', enter 20,000.'''
  
  
In the '''Memo '''field''',''' type as shown.
+
In the '''Memo '''field, type as shown.
  
 
|-
 
|-
Line 353: Line 356:
 
|-
 
|-
 
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click on '''View The GL Journal Entries for this Transfer'''
 
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click on '''View The GL Journal Entries for this Transfer'''
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| In the new window, we can see a message - “Transfer has been entered”
+
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| In the new window, we can see a message - '''“Transfer has been entered”'''.
  
 
Next link is '''View The GL Journal Entries for this Transfer.'''
 
Next link is '''View The GL Journal Entries for this Transfer.'''
  
Click on it''' '''to see the entries.
+
Click on it to see the '''entries'''.
  
 
|-
 
|-
 
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click on '''close'''  
 
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click on '''close'''  
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| A pop up window appears with the transaction details of the amount that has been transferred.
+
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| A pop up window appears with the '''transaction''' details of the amount that has been transferred.
  
 
Click on the '''Close''' link at the bottom of the window.
 
Click on the '''Close''' link at the bottom of the window.
Line 373: Line 376:
 
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Next, we will check the '''Bank Statements'''.
 
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Next, we will check the '''Bank Statements'''.
  
In the '''Transactions''' panel, on the right side, click on '''Reconcile Bank account '''link'''.'''
+
In the '''Transactions''' panel, on the right side, click on '''Reconcile Bank Account '''link.
  
 
It matches the '''deposits''' in the '''company accounts''' with those in the '''Bank statement'''.
 
It matches the '''deposits''' in the '''company accounts''' with those in the '''Bank statement'''.
Line 379: Line 382:
 
|-
 
|-
 
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Point to the output
 
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Point to the output
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| We can see the '''Account total, Bank Deposits and Fund transfer''' details.
+
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:0.75pt solid #000000;border-right:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| We can see the '''Account total, Bank Deposits''' and '''Fund transfer''' details.
  
 
This brings us to the end of this tutorial. Let us summarize.
 
This brings us to the end of this tutorial. Let us summarize.
Line 402: Line 405:
 
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| As an assignment  
 
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| As an assignment  
  
* Use '''Deposits''' option and deposit Rs.10,000 into '''Petty Cash account'''.
+
* Use '''Deposits''' option and '''deposit''' Rs.10,000 into '''Petty Cash account'''.
 
* Select '''Miscellaneous''' in the '''From''' field
 
* Select '''Miscellaneous''' in the '''From''' field
 
* Enter the '''Name''' as '''Mr. Rahul'''
 
* Enter the '''Name''' as '''Mr. Rahul'''
* Check the '''Reconcile Bank Account '''for''' Petty '''
+
* Check the '''Reconcile Bank Account '''for''' Petty Cash account'''
 
+
'''Cash account'''
+
  
 
|-
 
|-
Line 413: Line 414:
  
 
Acknowledgement  
 
Acknowledgement  
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| * The video at the following link summarises the Spoken Tutorial project.
+
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"|  
 +
* The video at the following link summarises the Spoken Tutorial project.
 
* Please download and watch it
 
* Please download and watch it
  
Line 421: Line 423:
 
About workshops
 
About workshops
  
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| * The '''Spoken Tutorial Project''' Team conducts workshops and gives certificates.
+
| style="border:0.75pt solid #000000;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"|  
 +
* The '''Spoken Tutorial Project''' Team conducts workshops and gives certificates.
 
* For more details, please write to us.  
 
* For more details, please write to us.  
  

Latest revision as of 12:22, 14 November 2019

Taxes and Bank Accounts in Frontaccounting

Visual Cue Narration
Slide 1

Title Slide

Taxes and Bank Accounts

Welcome to the spoken tutorial on Taxes and Bank Accounts in FrontAccounting.
Slide 2

Learning Objectives

  • Add a new Tax
  • Set the Bank Accounts
  • Add Deposits
  • Transfer amount in Bank Account
  • Reconcile Bank Account
In this tutorial,we will learn how to
  • Add a new Tax
  • Set up Bank Accounts
  • Add Deposits
  • Transfer amount into the Bank Account and
  • Reconcile the Bank Account
Slide 3

System Requirements

  • Ubuntu Linux OS version 14.04
  • FrontAccounting version 2.3.24
To record this tutorial, I am using
  • Ubuntu Linux OS version 16.04
  • FrontAccounting version 2.4.7
Slide 4

Pre -requisites To practise this tutorial, you must have knowledge of:

  • Higher secondary commerce & accounting
  • Principles of Bookkeeping
To practise this tutorial, you must have knowledge of:
  • Higher secondary commerce and accounting and
  • Principles of Bookkeeping
You should have already
  • Set up an Organisation/Company in FrontAccounting.
And you should have already set up an Organisation or Company in FrontAccounting.

If not, for relevant FrontAccounting tutorials please visit this website.

Slide 5:

Start XAMPP service

Start the XAMPP services before you begin working on FrontAccounting interface.
Narration Let us open the FrontAccounting interface.
Click on browser >>localhost/account >> Press Enter Open a web browser.

Type localhost/account and press Enter.

Narration The login page appears.
Enter Username = admin and Password = spoken>> Click on login Type the username as admin and the password.

Then click on Login button.

Click Setup tab >> Taxes The FrontAccounting interface opens.

Click on the Setup tab.

In the Company Setup panel, click on Taxes link.

We can see a default entry as Tax.

Point to default options of Tax The Percentage, Sales GL Account and Purchasing GL Account are specified as shown here.

We have to assign GL accounts to every tax used by our business.

Highlight the message

To avoid problems with manual journal entry all tax types should have unique Sales/Purchasing GL accounts”

At the top of the window, we can see a message.

It is recommended that a separate Sale and purchase GL account has to be assigned to each tax.

narration Let us see how to add GST and Service tax for our company.
Click on the Edit icon of Tax. Click on the Edit icon on the default entry Tax row.
Change the Description, Percentage

Click on the Update button.

I’ll edit Tax to GST , as our company will not use the default entry Tax.


I’ll change the description to GST and the percentage to 12.


I will keep the Sales GL account and Purchase GL Account as Sales tax.


Click on the Update button at the bottom of the window.

We have successfully changed the default entry Tax to GST.

Narration Now let us add Service tax.

Before that we have to create a GL Account for Service tax.

Click on Banking and general ledger

Click on GL accounts

Click on Banking and General Ledger tab.

In the Maintenance panel, click on GL Accounts link.

Type the value as shown:

Account code: 2151

Account Name : Service Tax

Account Group : Current Liabilities

Click on the Add account button

Type the values as shown:

Then click on the Add Account button at the bottom of the window.

Click on Setup tab and then on Taxes Now, click on Setup tab and then on Taxes link.
narration Let us add Service tax under Tax Types.
Type the value as shown:

Description: Service Tax

Default Rate: 7

Type the values as shown.
Click on Sales GL Account drop down box.

Select Service Tax

Click on Sales GL Account drop-down box.

Select Service Tax which is under Current Liabilities.

Show the demo of the selection

Click on Add new button

Likewise, select Service Tax for Purchase GL Account.

Click on Add new button at the bottom of the window.

Point to GST and Service Tax We can see that two taxes have now been added.
narration Let’s see how these taxes are calculated in the Sales module of FrontAccounting.
narration We will first set up a Bank Account for the company.
Click on Banking and General ledger

Click on Bank Accounts

Click on Banking and General ledger tab.

In the Maintenance panel, click on Bank Accounts link.

This option is used to setup and configure the bank and cash accounts.

Point to USD

Select Indian currency from the drop down box

By default, you can see Current account and Petty Cash account details.

The Currency column is in US Dollar, by default.

Let us change this to Indian currency.

Click on the Edit icon.

Select Chequing Account from the drop down box

Select Indian currency from the drop down box

In the Current account row, click on the Edit icon.

Change the Account type to Chequing Account.

Change the Bank account currency to Indian Rupees.

Click on update button.

Show the demo of petty cash

Then update the changes by clicking on the Update button at the bottom.

Likewise, change the Petty Cash account also to Indian Rupees.

And update the changes.

Narration Next let us add some amount to the ST Company Pvt. Ltd. bank account.
Click on Deposits link in the Banking and General ledger tab. Go to Banking and General ledger tab.

In the Transactions panel, click on Deposits link.

Narration Deposits from customers, miscellaneous sales, etc. can be entered here.
Data Entry demo


Name:Mr.Patel

Account description >>cash

Amount >> 3,00,000

memo >>Rent for the month December

Click on Add item

Keep the From field as Miscellaneous.

I’ll enter the name of the person who has deposited the money as shown.

In the Account description field, select Cash.

In the Amount field, type 3 lakhs.

In the Memo field, type the purpose of the deposit.

Then click on Add item button at the right end of the row.

Click on Process deposit Click on Process Deposit button at the bottom of the window.
New window >> success message In the new window, we can see a message that the deposit has been entered.
Click on View the GL postings for this Deposit Next link is View the GL postings for this Deposit. Click on it.
Point to the amount A pop up window appears with the transaction details of the amount that has been deposited.
Click on close Click on the Close link at the bottom of the window.
Point to the next link Enter another Deposit If you want to enter another deposit, then click on “Enter Another Deposit” link.
Click on back option. Click on Back link at the bottom of the window to go back to the FrontAccounting interface.
Narration Next we will see how to transfer money from bank account to cash or another account.
Click on Banking and General ledger>>Bank Account Transfers In the Transactions panel, click on Bank Account Transfers link.
Point to Bank Balance Notice that the Bank Balance is shown here as three lakh rupees.

Recall, this amount had been deposited earlier.

To account :Petty cash

amount :20,000

Memo : Money transferred for petty cash

In the To Account field, select Petty Cash account.

In the Amount field, enter 20,000.


In the Memo field, type as shown.

Click on Enter Transfer button. Click on Enter Transfer button at the bottom of the window.
Click on View The GL Journal Entries for this Transfer In the new window, we can see a message - “Transfer has been entered”.

Next link is View The GL Journal Entries for this Transfer.

Click on it to see the entries.

Click on close A pop up window appears with the transaction details of the amount that has been transferred.

Click on the Close link at the bottom of the window.

Click on Back Click on the Back link at the bottom of the window to go back to the FrontAccounting interface.
click on Reconcile Bank account. Next, we will check the Bank Statements.

In the Transactions panel, on the right side, click on Reconcile Bank Account link.

It matches the deposits in the company accounts with those in the Bank statement.

Point to the output We can see the Account total, Bank Deposits and Fund transfer details.

This brings us to the end of this tutorial. Let us summarize.

Slide 6

Summary

In this tutorial, we have learnt about
  • Add a new Tax
  • Set up Bank Accounts
  • Add Deposits
  • Transfer amount into the Bank Account
  • Reconcile the Bank Account
Slide 7

Assignment 1

As an assignment
  • Use Deposits option and deposit Rs.10,000 into Petty Cash account.
  • Select Miscellaneous in the From field
  • Enter the Name as Mr. Rahul
  • Check the Reconcile Bank Account for Petty Cash account
Slide 8

Acknowledgement

  • The video at the following link summarises the Spoken Tutorial project.
  • Please download and watch it
Slide 9

About workshops

  • The Spoken Tutorial Project Team conducts workshops and gives certificates.
  • For more details, please write to us.
Slide 10

Forum for specific questions

Please post your timed queries in this forum.
Slide 11

Acknowledgement

The Spoken Tutorial Project is funded by NMEICT, MHRD Government of India.

More information on this mission is available at this link.

The script and video has been contributed by Spoken Tutorial team.

This is Arvind Pillai signing off. Thanks for joining.

Contributors and Content Editors

Nancyvarkey, Nirmala Venkat