Difference between revisions of "FrontAccounting-2.4.7/C2/Taxes-and-Bank-Account-in-FrontAccounting/English"
(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...") |
Nancyvarkey (Talk | contribs) |
||
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'''. | ||
− | * | + | *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''' | + | | 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 | + | | 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 | + | | 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 | + | 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 | + | 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''' | + | 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''' | + | 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 | + | | 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 | + | 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 | + | | 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 | + | | 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 | + | | 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 | + | | 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 | + | 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''' ''' | + | 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 | + | 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''' |
− | + | ||
− | + | ||
|- | |- | ||
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
|
In this tutorial,we will learn how to
|
Slide 3
System Requirements
|
To record this tutorial, I am using
|
Slide 4
Pre -requisites To practise this tutorial, you must have knowledge of:
|
To practise this tutorial, you must have knowledge of:
|
You should have already
|
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.
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
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.
|
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
|
Slide 7
Assignment 1 |
As an assignment
|
Slide 8
Acknowledgement |
|
Slide 9
About workshops |
|
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. |