You are viewing an old version of this page. Return to the latest version.
Difference between revisions of "Petty Cash"
(Tag: 2017 source edit) |
(Tag: Visual edit) |
||
Line 4: | Line 4: | ||
==Petty Cash== | ==Petty Cash== | ||
Allows the user to create a petty cash for paying expenses. | Allows the user to create a petty cash for paying expenses. | ||
− | |||
− | |||
=====Requirements before using Petty Cash===== | =====Requirements before using Petty Cash===== | ||
Line 16: | Line 14: | ||
=====Adding Petty Cash===== | =====Adding Petty Cash===== | ||
− | # Go to Financials then click [[Petty Cash]] | + | #Go to Financials then click [[Petty Cash]] |
− | # Click '''Add Petty Cash''' Button | + | #Click '''Add Petty Cash''' Button |
− | # Fill up the necessary Fields on the Petty Cash Header | + | #Fill up the necessary Fields on the Petty Cash Header |
− | # Fill up the necessary Fields on the Accounting Details Section below the Petty Cash Header then Click '''Save.''' | + | #Fill up the necessary Fields on the Accounting Details Section below the Petty Cash Header then Click '''Save.''' |
{| class="wikitable" style="margin: auto;" | {| class="wikitable" style="margin: auto;" | ||
Line 80: | Line 78: | ||
=====Editing Petty Cash===== | =====Editing Petty Cash===== | ||
− | # Go to Financials then click [[Petty Cash]] | + | #Go to Financials then click [[Petty Cash]] |
− | # Select the [[Petty Cash]] that needs an update. Click the drop-down arrow then click '''Edit''' | + | #Select the [[Petty Cash]] that needs an update. Click the drop-down arrow then click '''Edit''' |
− | # Update the necessary fields then click '''Save''' to finish. | + | #Update the necessary fields then click '''Save''' to finish. |
{| class="wikitable" style="margin: auto;" | {| class="wikitable" style="margin: auto;" | ||
Line 147: | Line 145: | ||
*The Petty Cash will change its status to '''PAID''' if it is paid under [[Payment Voucher]]. | *The Petty Cash will change its status to '''PAID''' if it is paid under [[Payment Voucher]]. | ||
− | ===== <span class="mw-headline" id="Importing_and_Exporting_Journal_Voucher" style="box-sizing: inherit;">Importing and Exporting Journal Voucher</span> ===== | + | =====<span class="mw-headline" id="Importing_and_Exporting_Journal_Voucher" style="box-sizing: inherit;">Importing and Exporting Journal Voucher</span>===== |
1. Under Petty Cash Screen, Click Options | 1. Under Petty Cash Screen, Click Options | ||
2. Under Options, The user may Export or Import The Record | 2. Under Options, The user may Export or Import The Record | ||
− | * When Exporting the records, the user may also use the filter options such as Date Filter, Search Bar and Source filter for precise searching and exporting of records. | + | *When Exporting the records, the user may also use the filter options such as Date Filter, Search Bar and Source filter for precise searching and exporting of records. |
− | * When Importing the records, the user should follow the following steps provided in the Importing Petty Cash Screen such as | + | *When Importing the records, the user should follow the following steps provided in the Importing Petty Cash Screen such as |
− | ** Downloading the template link provided under Step 1. | + | **Downloading the template link provided under Step 1. |
− | ** Filling up the information needed for each columns of the template | + | **Filling up the information needed for each columns of the template |
− | ** Uploading the updated Template | + | **Uploading the updated Template |
+ | {| class="wikitable hw-responsive-data-table" 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: "Open Sans", 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;" |Import Data Dictionary of Petty Cash Voucher | ||
+ | ! style="background-color:rgb(234, 236, 240);text-align:center;" |Field | ||
+ | ! style="background-color:rgb(234, 236, 240);text-align:center;" |Description of Data Output | ||
+ | ! style="background-color:rgb(234, 236, 240);text-align:center;" |Allowed Inputs | ||
+ | ! style="background-color:rgb(234, 236, 240);text-align:center;" |Input Restrictions | ||
+ | ! style="background-color:rgb(234, 236, 240);text-align:center;" |Required (Y/N) | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |1.Document No. | ||
+ | | style="" |<span style="color: rgb(34, 34, 34)">Manual Entry of Document no of Journal Voucher</span> | ||
+ | | style="" |*Numeric | ||
+ | | style="" |*Other characters not mentioned in the allowed Inputs | ||
+ | | style="vertical-align:middle;text-align:center;" |Y | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |2.Payee | ||
+ | | style="" |Name of Payee | ||
+ | | style="" |*Supplier Code provided in [[Supplier]] Maintenance Module | ||
+ | | style="" |*Any inputs not mentioned in the allowed inputs | ||
+ | | style="vertical-align:middle;text-align:center;" |Y | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |3.Document Date | ||
+ | | style="" |Manual Entry of the Document Date when the transaction was created | ||
+ | | style="" |*Numeric | ||
+ | <nowiki>*</nowiki>Dash "-" | ||
+ | |||
+ | <nowiki>*</nowiki>Backslash "\" | ||
+ | | style="" |*Other special characters not mentioned | ||
+ | | style="vertical-align:middle;text-align:center;" |Y | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |4.Credit Account | ||
+ | | style="" |Account to be charged for credit on the transaction | ||
+ | | style="" |*Account Code provided in [[Chart of Account]] Maintenance Module | ||
+ | | style="" |*Any inputs not mentioned in the allowed inputs | ||
+ | | style="vertical-align:middle;text-align:center;" |Y | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |5.Notes | ||
+ | | style="" |Other Remarks on the Transaction | ||
+ | | style="" |*Alphanumeric | ||
+ | <nowiki>*</nowiki>Special Characters | ||
+ | | style="" |*None | ||
+ | | style="vertical-align:middle;text-align:center;" |N | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |6.Transaction Date | ||
+ | | style="" |Date of Transaction | ||
+ | | style="" |<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{"style":"color: rgb(34, 34, 34)"}">*Numeric</span> | ||
+ | <nowiki>*</nowiki>Dash "-" | ||
+ | |||
+ | <nowiki>*</nowiki>Backslash "\" | ||
+ | | style="" |*Other special characters not mentioned | ||
+ | | style="vertical-align:middle;text-align:center;" |Y | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |7.Supplier Code | ||
+ | | style="" |Supplier Code of the Supplier | ||
+ | | style="" |*Supplier Code provided in [[Supplier]] Maintenance Module | ||
+ | | style="" |*Any inputs not mentioned in the allowed inputs | ||
+ | | style="vertical-align:middle;text-align:center;" |Y | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |8.Account Code | ||
+ | | style="" |Account to be charged on the transaction | ||
+ | | style="" |*Account Code provided in [[Chart of Account]] Maintenance Module | ||
+ | | style="" |*Any inputs not mentioned in the allowed inputs | ||
+ | | style="vertical-align:middle;text-align:center;" |Y | ||
+ | |- | ||
+ | |9.Price | ||
+ | |Price to be paid in the transaction | ||
+ | |*Numeric | ||
+ | |*Any input except Numeric | ||
+ | | style="vertical-align:middle;text-align:center;" |Y | ||
+ | |- | ||
+ | |10.Tax Code | ||
+ | |Type of Tax to be applied on the Transaction | ||
+ | |*Tax Code provided in [[Tax]] Maintenance Module | ||
+ | |*Any inputs not mentioned in the allowed inputs | ||
+ | | style="vertical-align:middle;text-align:center;" |N | ||
+ | |} | ||
<br /> | <br /> | ||
=====Petty Cash Record Options===== | =====Petty Cash Record Options===== | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
{| class="wikitable hw-responsive-data-table" 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: "Open Sans", 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;" | {| class="wikitable hw-responsive-data-table" 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: "Open Sans", 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 | + | |+ 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 Petty Cash Record Status |
! style="background-color:rgb(234, 236, 240);text-align:center;" |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;" |View | ||
Line 201: | Line 265: | ||
*The user can Edit the Petty Cash Record while viewing | *The user can Edit the Petty Cash Record while viewing | ||
**The user can only edit it while the status of the Petty Cash is '''UNPAID''' | **The user can only edit it while the status of the Petty Cash is '''UNPAID''' | ||
− | * The Record will change its status from UNPAID to PAID ones the petty cash payment in [[Payment Voucher]] is '''POSTED''' | + | *The Record will change its status from UNPAID to PAID ones the petty cash payment in [[Payment Voucher]] is '''POSTED''' |
− | * Petty Cash can only be cancelled if it is still on '''UNPAID''' Status. | + | *Petty Cash can only be cancelled if it is still on '''UNPAID''' Status. |
**The user must Unpost and cancel the [[Payment Voucher]] first in order to cancel the Petty Cash Record. | **The user must Unpost and cancel the [[Payment Voucher]] first in order to cancel the Petty Cash Record. | ||
Line 214: | Line 278: | ||
|Maintenance | |Maintenance | ||
|[[Supplier]]<nowiki> | </nowiki>[[Chart of Account]]<nowiki> | </nowiki>[[Tax]] | |[[Supplier]]<nowiki> | </nowiki>[[Chart of Account]]<nowiki> | </nowiki>[[Tax]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|} | |} |
Revision as of 13:24, 21 December 2021
Contents
Petty Cash
Allows the user to create a petty cash for paying expenses.
Requirements before using Petty Cash
- The user should setup the following Maintenance Module in order to proceed on using the Petty Cash
Petty Cash Record List
Adding Petty Cash
- Go to Financials then click Petty Cash
- Click Add Petty Cash Button
- Fill up the necessary Fields on the Petty Cash Header
- Fill up the necessary Fields on the Accounting Details Section below the Petty Cash Header then Click Save.
Field | Description | Expected Values |
---|---|---|
1.Petty Cash Voucher | •Auto Generated Petty Cash reference number upon creation | •Alphanumeric (Auto-Generated) |
2.Payee | •Name of Payee | •Suppliers List from Supplier Maintenance Module |
3.Document Date | •Date when the transaction was created | •Date |
4.Credit Account | •Account to be charged for credit on the transaction | •Account list in the Chart of Accounts Maintenance Module |
5.Notes | •Other Remarks on the Transaction | •Alphanumeric |
6.Transaction Date | •Date of Transaction | •Date |
7.Supplier | •Name of Supplier | •Supplier List in the Supplier Maintenance Module |
8.Account | •Account to be charged on the transaction | •Account list in the Chart of Accounts Maintenance Module |
9.Price | •Price to be paid in the transaction | •Amount/Number |
10.Tax | •Type of Tax to be applied on the Transaction | •Tax List provided in the Tax Maintenance Module |
11.Amount | •Total amount in the transaction line on each account | •Number |
Notes:
- Account should be on ACTIVE status when using it upon creating or editing a transaction.
- This can be seen in Chart of Account Maintenance Module.
- Supplier/Payee should be on ACTIVE status when using it upon creating or editing a transaction.
- This can be seen in Supplier Maintenance Module
- Tax should be on ACTIVE status when using it upon creating or editing a transaction.
- This can be seen in Tax Maintenance Module
Editing Petty Cash
- Go to Financials then click Petty Cash
- Select the Petty Cash that needs an update. Click the drop-down arrow then click Edit
- Update the necessary fields then click Save to finish.
Field | Description | Expected Values |
---|---|---|
1.Petty Cash Voucher | •Auto Generated Petty Cash reference number upon creation | •Alphanumeric (Auto-Generated) |
2.Payee | •Name of Payee | •Suppliers List from Supplier Maintenance Module |
3.Document Date | •Date when the transaction was created | •Date |
4.Credit Account | •Account to be charged for credit on the transaction | •Account list in the Chart of Accounts Maintenance Module |
5.Notes | •Other Remarks on the Transaction | •Alphanumeric |
6.Transaction Date | •Date of Transaction | •Date |
7.Supplier | •Name of Supplier | •Supplier List in the Supplier Maintenance Module |
8.Account | •Account to be charged on the transaction | •Account list in the Chart of Accounts Maintenance Module |
9.Price | •Price to be paid in the transaction | •Amount/Number |
10.Tax | •Type of Tax to be applied on the Transaction | •Tax List provided in the Tax Maintenance Module |
11.Amount | •Total amount in the transaction line on each account | •Number |
Notes:
- Supplier/Payee should be on ACTIVE status when using it upon creating or editing a transaction.
- This can be seen in Supplier Maintenance Module
- Past Transactions with INACTIVE status prior to its deactivation can still be used.
- Tax should be on ACTIVE status when using it upon creating or editing a transaction.
- This can be seen in Tax Maintenance Module
- Past Transactions with INACTIVE status prior to its deactivation can still be used.
- Account should be on ACTIVE status when using it upon creating or editing a transaction.
- This can be seen in Chart of Account Maintenance Module.
- The user can only edit the Petty Cash Transaction if it is still in UNPAID status.
- The user must Unpost and cancel the Payment Voucher first in order to edit the Petty Cash Record.
- The Petty Cash will change its status to PAID if it is paid under Payment Voucher.
Importing and Exporting Journal Voucher
1. Under Petty Cash 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 such as Date Filter, Search Bar and Source filter for precise searching and exporting of records.
- When Importing the records, the user should follow the following steps provided in the Importing Petty Cash 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
Field | Description of Data Output | Allowed Inputs | Input Restrictions | Required (Y/N) |
---|---|---|---|---|
1.Document No. | Manual Entry of Document no of Journal Voucher | *Numeric | *Other characters not mentioned in the allowed Inputs | Y |
2.Payee | Name of Payee | *Supplier Code provided in Supplier Maintenance Module | *Any inputs not mentioned in the allowed inputs | Y |
3.Document Date | Manual Entry of the Document Date when the transaction was created | *Numeric
*Dash "-" *Backslash "\" |
*Other special characters not mentioned | Y |
4.Credit Account | Account to be charged for credit on the transaction | *Account Code provided in Chart of Account Maintenance Module | *Any inputs not mentioned in the allowed inputs | Y |
5.Notes | Other Remarks on the Transaction | *Alphanumeric
*Special Characters |
*None | N |
6.Transaction Date | Date of Transaction | *Numeric
*Dash "-" *Backslash "\" |
*Other special characters not mentioned | Y |
7.Supplier Code | Supplier Code of the Supplier | *Supplier Code provided in Supplier Maintenance Module | *Any inputs not mentioned in the allowed inputs | Y |
8.Account Code | Account to be charged on the transaction | *Account Code provided in Chart of Account Maintenance Module | *Any inputs not mentioned in the allowed inputs | Y |
9.Price | Price to be paid in the transaction | *Numeric | *Any input except Numeric | Y |
10.Tax Code | Type of Tax to be applied on the Transaction | *Tax Code provided in Tax Maintenance Module | *Any inputs not mentioned in the allowed inputs | N |
Petty Cash Record Options
Status | View | Edit | Cancel | |
---|---|---|---|---|
UNPAID | ☑ | ☑ | ☑ | ☑ |
PAID | ☑ | ☑ | ||
CANCELLED | ☑ | ☑ |
Notes:
- The user can Edit the Petty Cash Record while viewing
- The user can only edit it while the status of the Petty Cash is UNPAID
- The Record will change its status from UNPAID to PAID ones the petty cash payment in Payment Voucher is POSTED
- Petty Cash can only be cancelled if it is still on UNPAID Status.
- The user must Unpost and cancel the Payment Voucher first in order to cancel the Petty Cash Record.
Modules | |
---|---|
Financials | Financials | Petty Cash | Payment Voucher |
Maintenance | Supplier | Chart of Account | Tax |