Difference between revisions of "Tax"

(Tag: 2017 source edit)
Line 8: Line 8:
 
*The user should setup the following [[Maintenance]] Module in order to proceed on using the [[Tax]]
 
*The user should setup the following [[Maintenance]] Module in order to proceed on using the [[Tax]]
 
*#[[Chart of Account]]
 
*#[[Chart of Account]]
*For detailed instructions on how to setup the needed [[Maintenance]] Module, the user may visit the following Job Aid pages:
 
*#[[Chart of Accounts Aids]]
 
  
 
=====Tax Record List=====
 
=====Tax Record List=====
[[File:Tax Record List.png|center|thumb|Tax Record List]]Notes:
+
Notes:
  
 
*Tax, as long as its status is '''ACTIVE''' can be used in the following modules:
 
*Tax, as long as its status is '''ACTIVE''' can be used in the following modules:
Line 24: Line 22:
 
*Past Transactions with '''INACTIVE''' tax can still be used prior to its deactivation but for new transactions, '''INACTIVE''' tax cannot be used.
 
*Past Transactions with '''INACTIVE''' tax can still be used prior to its deactivation but for new transactions, '''INACTIVE''' tax cannot be used.
  
=====Adding Tax=====
+
=====Adding Tax Record=====
[[File:Adding Tax.png|center|thumb|866x866px|Adding Tax]]
+
 
{| class="wikitable"
+
#Go to Maintenance then click [[Tax]]
 +
#Click '''Add Tax''' Button
 +
#Fill up the necessary fields. Please make sure that all tabs are filled out then click '''Save.'''
 +
 
 +
{| class="wikitable" style="margin: auto;"
 
!Field
 
!Field
 
!Description
 
!Description
Line 63: Line 65:
 
*Tax Code is a unique required field in the Module. This field cannot be edited once the Tax Record is created.
 
*Tax Code is a unique required field in the Module. This field cannot be edited once the Tax Record is created.
 
*Tax Count is a required field. Accounts can be used from [[Chart of Account]] as long as the status of that account is '''ACTIVE'''
 
*Tax Count is a required field. Accounts can be used from [[Chart of Account]] as long as the status of that account is '''ACTIVE'''
*For detailed instructions on how to create a Tax Record, the user may visit the Tax Maintenance Code which can be found [[Tax Aids|here]]
 
  
=====Editing Tax=====
+
=====Editing Tax Record=====
[[File:Editing Tax.png|center|thumb|866x866px|Editing Tax]]
+
 
{| class="wikitable"
+
# Go to Maintenance then click [[Tax]]
 +
# Select the Tax that needs an update. Click the drop-down arrow then click '''Edit'''
 +
# Update the necessary Fields and Click '''Save'''
 +
 
 +
{| class="wikitable" style="margin: auto;"
 
!Field
 
!Field
 
!Description
 
!Description
Line 99: Line 104:
 
*Tax Count is a required field. Accounts can be used from [[Chart of Account|Chart of Accounts]] as long as the status of that account is '''ACTIVE'''
 
*Tax Count is a required field. Accounts can be used from [[Chart of Account|Chart of Accounts]] as long as the status of that account is '''ACTIVE'''
 
**The status of Accounts can be seen in [[Chart of Account]] Maintenance Module
 
**The status of Accounts can be seen in [[Chart of Account]] Maintenance Module
*For further instructions on how to edit a Tax Record, the user may visit the Tax Job aids which can be found [[Tax Aids|here]]
 
  
=====Tax Options=====
+
=====Importing and Exporting Option=====
[[File:Tax Options.png|center|thumb|Tax Options]]Notes:
+
1. Under Chart of Account Screen, Click Options
  
*For further instructions on how to Import and Export a Tax Record, the user may visit the Tax Job aids which can be found [[Tax Aids|here]]<br />
+
2. Under Options, The user may Export or Import The Record
  
=====Tax Importing Option=====
+
*When Exporting the records, the user may also use the filter options through tabs for precise searching and exporting of records.
[[File:Tax Importing Option.png|center|thumb|Tax Importing Option]]Notes:
+
*When Importing the records, the user should follow the following steps provided in the Importing Tax Screen such as
 +
**Downloading the template link provided under Step 1.
 +
**Filling up the information needed for each columns of the template
 +
**Uploading the updated Template
  
*For further instructions on how to Import a Tax Record, the user may visit the Tax Job aids which can be found [[Tax Aids|here]]
+
{| class="wikitable" style="box-sizing: inherit; border-collapse: collapse; border-spacing: 0px; background-color: rgb(248, 249, 250); font-size: 14px; color: rgb(34, 34, 34); margin: auto; border: 1px solid rgb(162, 169, 177); font-family: &quot;Open Sans&quot;, Roboto, arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit; border-collapse: collapse; border-spacing: 0px; background-color: rgb(248, 249, 250); font-size: 14px; color: rgb(34, 34, 34); margin: auto; border: 1px solid rgb(162, 169, 177); font-family: \&quot;Open Sans\&quot;, Roboto, arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;&quot;}"
 +
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;&quot;}" |Tax Import Details
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;background-color:rgb(234, 236, 240);text-align:center;&quot;}" |'''Field'''
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;background-color:rgb(234, 236, 240);text-align:center;&quot;}" |'''Description'''
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;background-color:rgb(234, 236, 240);text-align:center;&quot;}" |'''Allowed Inputs'''
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;background-color:rgb(234, 236, 240);text-align:center;&quot;}" |'''Input Restrictions'''
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;background-color:rgb(234, 236, 240);text-align:center;&quot;}" |'''Required Field?'''
 +
|- style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}"
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |1.Tax Code
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |Reference Code for Tax
 +
| style="vertical-align:middle;text-align:left;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:left;&quot;}" |*Alphanumeric
 +
<nowiki>*</nowiki>Special Characters
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |*Up to 10 characters
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 +
|- style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}"
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |2.Tax Name
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |Name of Tax
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |*Alphanumeric
 +
<nowiki>*</nowiki>Special Characters
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |*Up to 50 characters
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 +
|- style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}"
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |3.Tax Description
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |Description of Tax
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |*Alphanumeric
 +
<nowiki>*</nowiki>Special Characters
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |*Up to 100 characters
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |No
 +
|- style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}"
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |4.Tax Rate
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |Rate to be Apply when applying tax
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |*Numeric(1-100)
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |*Any input greater than 100
  
=====Tax Record Option=====
+
<nowiki>*</nowiki>Alphabet
[[File:Tax Record Option.png|center|thumb|Tax Record Option]]Notes:
+
 
 +
<nowiki>*</nowiki>Special Characters
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 +
|- style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}"
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |5.Tax Type
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |Nature of Tax
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |*Input Tax
 +
<nowiki>*</nowiki>Output Tax
  
*For further instructions on how to View, Edit, Deactivate/Activate and Delete a Tax Record, the user may visit the Tax Job aids which can be found [[Tax Aids|here]]
+
<nowiki>*</nowiki>Percentage Tax
  
=====Tax View Record=====
+
<nowiki>*</nowiki>Withholding Tax
[[File:Tax View Record.png|center|thumb|Tax View Record]]
+
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |*Any inputs not mentioned in the allowed inputs
<br />Notes:
+
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 +
|- style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}"
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |6.Tax Account
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |Account to be applied when applying tax
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |*Account Code under Account List provided  in Chart of Account Maintenance Module
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |*Any inputs not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 +
|- style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}"
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |7.Transaction Type
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |Type of Transaction when applying Tax
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |*Sales
 +
<nowiki>*</nowiki>Purchase
 +
 
 +
<nowiki>*</nowiki>Both
 +
| style="" data-ve-attributes="{&quot;style&quot;:&quot;&quot;}" |*Any inputs not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 +
|}
 +
=====Tax Record Option=====
 +
{| class="wikitable" style="box-sizing: inherit; border-collapse: collapse; border-spacing: 0px; background-color: rgb(248, 249, 250); font-size: 14px; color: rgb(34, 34, 34); margin: auto; border: 1px solid rgb(162, 169, 177); font-family: &quot;Open Sans&quot;, Roboto, arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"
 +
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" |Actions Available base on Tax Record Status
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Status
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |View
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Edit
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Deactivate
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Activate
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Delete
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''ACTIVE'''
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''INACTIVE'''
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
|}
 +
Notes:
  
 
*The user can edit the details while viewing the record.
 
*The user can edit the details while viewing the record.
*For further instructions on how to Import and Export a Tax Record, the user may visit the Tax Job aids which can be found [[Tax Aids|here]]
+
*Tax that has been in transactions or other maintenance modules cannot be deleted.
 +
* '''INACTIVE''' Tax cannot be used in the transaction but the '''INACTIVE''' Tax on the past transactions can still use it.
 +
* Activating/Deactivating and Deleting of Records can be done in two ways.
 +
** For single records, the user may use the drop down arrow then the action that need to perform.
 +
** For multiple records, the user may tick the records then click the action button that need to perform
 +
*** Click the Yes in the confirmation to proceed on the action taken.
  
{| class="wikitable"
+
<br />
 +
{| class="wikitable" style="margin: auto;"
 
|+Categories:
 
|+Categories:
 
! colspan="2" |'''Modules'''
 
! colspan="2" |'''Modules'''
Line 138: Line 231:
 
|Financials
 
|Financials
 
|[[Accounts Payable]]<nowiki> | </nowiki>[[Accounts Receivable]]
 
|[[Accounts Payable]]<nowiki> | </nowiki>[[Accounts Receivable]]
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
|-
 
|Maintenance Aids
 
|[[Chart of Accounts Aids]]<nowiki> | </nowiki>[[Tax Aids]]
 
|-
 
|Sales Aids
 
|[[Sales Quotation Aids]]<nowiki> | </nowiki>[[Sales Order Aids]]<nowiki> | </nowiki>[[Sales Invoice Aids]]
 
|-
 
|Purchase Aids
 
|[[Purchase Order Aid]]
 
|-
 
|Financials Aids
 
|[[Accounts Payable Aids]]<nowiki> | </nowiki>[[Accounts Receivable Aids]]
 
 
|}
 
|}

Revision as of 10:44, 16 December 2021

Tax

This maintenance screen allows the user to configure and add tax types to be used on their transactions.

Requirements before using Tax
Tax Record List

Notes:

Adding Tax Record
  1. Go to Maintenance then click Tax
  2. Click Add Tax Button
  3. Fill up the necessary fields. Please make sure that all tabs are filled out then click Save.
Field Description Expected Output
1.Tax Code •Reference Code for Tax •Alphanumeric
2.Tax Name •Name of Tax •Alphanumeric
3.Tax Description •Description of Tax •Alphanumeric
4.Tax Rate •Rate to be Apply when applying tax •Number
5.Tax Type •Nature of Tax •Tax Type Field List
6.Tax Account •Account to be applied when applying tax •Account List under Chart of Account Maintenance Module
7.Transaction Type •Type of Transaction when applying Tax •Sales/Purchase/Both

Notes:

  • Tax Code is a unique required field in the Module. This field cannot be edited once the Tax Record is created.
  • Tax Count is a required field. Accounts can be used from Chart of Account as long as the status of that account is ACTIVE
Editing Tax Record
  1. Go to Maintenance then click Tax
  2. Select the Tax that needs an update. Click the drop-down arrow then click Edit
  3. Update the necessary Fields and Click Save
Field Description Expected Output
1.Tax Name •Name of Tax •Alphanumeric
2.Tax Description •Description of Tax •Alphanumeric
3.Tax Rate •Rate to be Apply when applying tax •Number
4.Tax Type •Nature of Tax •Tax Type Field List
5.Tax Account •Account to be applied when applying tax •Account List under Chart of Account Maintenance Module
6.Transaction Type •Type of Transaction when applying Tax •Sales/Purchase/Both

Notes:

  • Tax Count is a required field. Accounts can be used from Chart of Accounts as long as the status of that account is ACTIVE
Importing and Exporting Option

1. Under Chart of Account Screen, Click Options

2. Under Options, The user may Export or Import The Record

  • When Exporting the records, the user may also use the filter options through tabs for precise searching and exporting of records.
  • When Importing the records, the user should follow the following steps provided in the Importing Tax Screen such as
    • Downloading the template link provided under Step 1.
    • Filling up the information needed for each columns of the template
    • Uploading the updated Template
Tax Import Details
Field Description Allowed Inputs Input Restrictions Required Field?
1.Tax Code Reference Code for Tax *Alphanumeric

*Special Characters

*Up to 10 characters Yes
2.Tax Name Name of Tax *Alphanumeric

*Special Characters

*Up to 50 characters Yes
3.Tax Description Description of Tax *Alphanumeric

*Special Characters

*Up to 100 characters No
4.Tax Rate Rate to be Apply when applying tax *Numeric(1-100) *Any input greater than 100

*Alphabet

*Special Characters

Yes
5.Tax Type Nature of Tax *Input Tax

*Output Tax

*Percentage Tax

*Withholding Tax

*Any inputs not mentioned in the allowed inputs Yes
6.Tax Account Account to be applied when applying tax *Account Code under Account List provided  in Chart of Account Maintenance Module *Any inputs not mentioned in the allowed inputs Yes
7.Transaction Type Type of Transaction when applying Tax *Sales

*Purchase

*Both

*Any inputs not mentioned in the allowed inputs Yes
Tax Record Option
Actions Available base on Tax Record Status
Status View Edit Deactivate Activate Delete
ACTIVE
INACTIVE

Notes:

  • The user can edit the details while viewing the record.
  • Tax that has been in transactions or other maintenance modules cannot be deleted.
  • INACTIVE Tax cannot be used in the transaction but the INACTIVE Tax on the past transactions can still use it.
  • Activating/Deactivating and Deleting of Records can be done in two ways.
    • For single records, the user may use the drop down arrow then the action that need to perform.
    • For multiple records, the user may tick the records then click the action button that need to perform
      • Click the Yes in the confirmation to proceed on the action taken.


Categories:
Modules
Maintenance Maintenance | Tax | Chart of Account
Sales Sales Quotation | Sales Order | Sales Invoice
Purchase Purchase Order
Financials Accounts Payable | Accounts Receivable