Difference between revisions of "Petty Cash"

(Tag: 2017 source 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.
 
<br />
 
 
=====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: &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;" |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="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">*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=====
[[File:Petty Cash Record Option.png|center|thumb|Petty Cash Record Option]]
 
 
Notes:
 
 
**
 
 
*<span style="color: rgb(51, 51, 51)">For detailed steps on how to View, Edit, Print and Cancel a Petty Cash, you can visit the Petty Cash Job Aids which can be found [[Petty Cash Aids|here]]</span>
 
 
=====Petty Cash View Record=====
 
 
{| 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: &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;"
 
{| 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: &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 Disbursement Voucher Record Status
+
|+ 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]]
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
|-
 
|Financials Aids
 
|[[Petty Cash Aids]]<nowiki> | </nowiki>[[Payment Voucher Aids]]
 
|-
 
|Maintenance Aids
 
|[[Supplier Aids]]<nowiki> | </nowiki>[[Chart of Accounts Aids]]<nowiki> | </nowiki>[[Tax Aids]]
 
 
|}
 
|}

Revision as of 13:24, 21 December 2021

Petty Cash

Allows the user to create a petty cash for paying expenses.

Requirements before using Petty Cash
Petty Cash Record List
Adding Petty Cash
  1. Go to Financials then click Petty Cash
  2. Click Add Petty Cash Button
  3. Fill up the necessary Fields on the Petty Cash Header
  4. 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.
  • 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
  1. Go to Financials then click Petty Cash
  2. Select the Petty Cash that needs an update. Click the drop-down arrow then click Edit
  3. 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.
  • 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
Import Data Dictionary of Petty Cash Voucher
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
Actions Available base on Petty Cash Record Status
Status View Edit Print 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.
Categories:
Modules
Financials Financials | Petty Cash | Payment Voucher
Maintenance Supplier | Chart of Account | Tax