Difference between revisions of "Journal Voucher"

 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
[[Financials]] | [[Journal Voucher Aids]] | [[Depreciation Run]]
+
[[Financials]] | [[Inventory]] | [[General Journal]]
 
</div><br />
 
</div><br />
 
==Journal Voucher==
 
==Journal Voucher==
Line 9: Line 9:
 
**[[Chart of Account]]
 
**[[Chart of Account]]
 
**[[Proforma]]
 
**[[Proforma]]
*For detailed instructions on how to setup the needed [[Maintenance]] Module, the user may visit the following Job Aid pages:
 
**[[Chart of Accounts Aids]]
 
**[[Proforma Aids]]
 
  
 
=====Journal Voucher Record List=====
 
=====Journal Voucher Record List=====
[[File:Journal Voucher Record List.png|center|thumb|Journal Voucher Record List]]
+
[[File:Financials - Journal Voucher - Record List.png|border|center|1500x1500px]]
 +
<br />
 +
=====Adding Journal Voucher=====
  
=====Adding Journal Voucher=====
+
#Click [[Journal Voucher]] Voucher under Financials Menu
[[File:Adding Journal Voucher.png|center|thumb|863x863px|Adding Journal Voucher]]
+
#Under Journal Voucher Screen, Click '''Add Journal Voucher'''
 +
#Fill out the necessary fields in the header section
 +
#Fill out the necessary fields in the Accounting then Click '''Save'''
 +
 
 +
[[File:Financials - Journal Voucher - Add.png|border|center|1501x1501px]]
 +
<br />
 
{| class="wikitable"
 
{| class="wikitable"
 +
!'''Field'''
 +
!'''Description'''
 +
!'''Allowed Inputs'''
 +
!'''Restricted Inputs'''
 +
!'''Character Limit'''
 +
!'''Required Field?'''
 +
|-
 
|1.Voucher No.
 
|1.Voucher No.
 
|•Voucher Number of the Transaction upon creation
 
|•Voucher Number of the Transaction upon creation
 
|•Alphanumeric(Auto-Generated)
 
|•Alphanumeric(Auto-Generated)
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |N/A
 
|-
 
|-
 
|2.Reference No.
 
|2.Reference No.
 
|•Reference Number of the Transaction
 
|•Reference Number of the Transaction
 
|•Alphanumeric
 
|•Alphanumeric
 +
•Special Characters
 +
| style="vertical-align:middle;text-align:center;" |None
 +
| style="vertical-align:middle;text-align:center;" |50
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|-
 
|-
 
|3.Transaction Date
 
|3.Transaction Date
 
|•Date when the Transaction was Created
 
|•Date when the Transaction was Created
|•Date
+
|•Date picker provided by system
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|-
 
|-
 
|4.[[Proforma]]
 
|4.[[Proforma]]
 
|•Financial statements is to facilitate comparisons of historic data and projections of future performance.
 
|•Financial statements is to facilitate comparisons of historic data and projections of future performance.
 
|•Proforma list provided in the Proforma Maintenance Module
 
|•Proforma list provided in the Proforma Maintenance Module
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |No
 
|-
 
|-
 
|5.Notes
 
|5.Notes
 
|•Other Remarks on the Transaction
 
|•Other Remarks on the Transaction
 
|•Alphanumeric
 
|•Alphanumeric
 +
•Special Characters
 +
| style="vertical-align:middle;text-align:center;" |None
 +
| style="vertical-align:middle;text-align:center;" |300
 +
| style="vertical-align:middle;text-align:center;" |No
 
|-
 
|-
 
|6.[[Chart of Account|Account]]
 
|6.[[Chart of Account|Account]]
 
|•Account to be charged for credit and debit amount on the transaction
 
|•Account to be charged for credit and debit amount on the transaction
 
|•Account list in the Chart of Accounts Maintenance Module
 
|•Account list in the Chart of Accounts Maintenance Module
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|-
 
|-
 
|7.Description
 
|7.Description
 
|•Any remarks or description on the Account
 
|•Any remarks or description on the Account
 
|•Alphanumeric
 
|•Alphanumeric
 +
•Special Characters
 +
| style="vertical-align:middle;text-align:center;" |None
 +
| style="vertical-align:middle;text-align:center;" |100
 +
| style="vertical-align:middle;text-align:center;" |No
 
|-
 
|-
 
|8.Debit
 
|8.Debit
 
|•Debit Amount for the Transaction
 
|•Debit Amount for the Transaction
 
|•Number
 
|•Number
 +
| style="vertical-align:middle;text-align:center;" |Any inputs aside numbers
 +
| style="vertical-align:middle;text-align:center;" |20
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|-
 
|-
 
|9.Credit
 
|9.Credit
 
|•Credit Amount for the Transaction
 
|•Credit Amount for the Transaction
 
|•Number
 
|•Number
 +
| style="vertical-align:middle;text-align:center;" |Any inputs aside numbers
 +
| style="vertical-align:middle;text-align:center;" |20
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|}Notes:
 
|}Notes:
  
Line 61: Line 102:
 
*<span style="color: rgb(51, 51, 51)">Account should be on '''ACTIVE''' status when using it upon creating or editing a transaction.</span>
 
*<span style="color: rgb(51, 51, 51)">Account should be on '''ACTIVE''' status when using it upon creating or editing a transaction.</span>
 
**This can be seen in [[Chart of Account]] Maintenance Module.
 
**This can be seen in [[Chart of Account]] Maintenance Module.
*Journal Voucher is autogenerated when Running a [[Depreciation Run|Depreciation]].
 
 
*Journal Voucher is autogenerated when creating a [[Sales Return]].
 
*Journal Voucher is autogenerated when creating a [[Sales Return]].
 
*Journal Voucher is autogenerated when creating a [[Purchase Return]].
 
*Journal Voucher is autogenerated when creating a [[Purchase Return]].
 
*Only one user can use Add Voucher function at a time.
 
*Only one user can use Add Voucher function at a time.
*For detailed steps on how to create a Journal Voucher, you can visit the Journal Voucher Job Aids which can be found [[Journal Voucher Aids|here]]
 
  
 +
=====Viewing Journal Voucher=====
 +
 +
#Click [[Journal Voucher]] Voucher under Financials Menu
 +
#Select Journal Voucher that needs to view its details, click the drop-down arrow then choose '''View.'''
 +
#The user has an option to Edit the Journal Voucher upon viewing it. The Journal can only be edit if the Voucher was created manually.
 +
 +
[[File:Financials - Journal Voucher - View.png|center|1500x1500px]]
 +
<br />
 
=====Editing Journal Voucher=====
 
=====Editing Journal Voucher=====
[[File:Editing Journal Voucher.png|center|thumb|861x861px|Editing Journal Voucher]]
+
 
<br />
+
#Click [[Journal Voucher]] Voucher under Financials Menu
 +
#Select the Journal Voucher that needs to update its details, click the drop-down arrow then click '''Edit.'''
 +
#Update the necessary the fields. Then click '''Save.'''
 +
 
 +
[[File:Financials - Journal Voucher - Edit.png|border|center|1500x1500px]]
 
{| class="wikitable"
 
{| class="wikitable"
!Field
+
!'''Field'''
!Description
+
!'''Description'''
!Expected Values
+
!'''Allowed Inputs'''
 +
!'''Restricted Inputs'''
 +
!'''Character Limit'''
 +
!'''Required Field?'''
 
|-
 
|-
 
|1.Voucher No.
 
|1.Voucher No.
 
|•Voucher Number of the Transaction upon creation
 
|•Voucher Number of the Transaction upon creation
 
|•Alphanumeric(Auto-Generated)
 
|•Alphanumeric(Auto-Generated)
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 
|-
 
|-
 
|2.Reference No.
 
|2.Reference No.
 
|•Reference Number of the Transaction
 
|•Reference Number of the Transaction
 
|•Alphanumeric
 
|•Alphanumeric
 +
•Special Characters
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |None
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |50
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 
|-
 
|-
 
|3.Transaction Date
 
|3.Transaction Date
 
|•Date when the Transaction was Created
 
|•Date when the Transaction was Created
|•Date
+
|•Date picker provided by system
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 
|-
 
|-
 
|4.[[Proforma]]
 
|4.[[Proforma]]
 
|•Financial statements is to facilitate comparisons of historic data and projections of future performance.
 
|•Financial statements is to facilitate comparisons of historic data and projections of future performance.
 
|•Proforma list provided in the Proforma Maintenance Module
 
|•Proforma list provided in the Proforma Maintenance Module
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |No
 
|-
 
|-
 
|5.Notes
 
|5.Notes
 
|•Other Remarks on the Transaction
 
|•Other Remarks on the Transaction
 
|•Alphanumeric
 
|•Alphanumeric
 +
•Special Characters
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |None
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |300
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |No
 
|-
 
|-
 
|6.[[Chart of Account|Account]]
 
|6.[[Chart of Account|Account]]
 
|•Account to be charged for credit and debit amount on the transaction
 
|•Account to be charged for credit and debit amount on the transaction
 
|•Account list in the Chart of Accounts Maintenance Module
 
|•Account list in the Chart of Accounts Maintenance Module
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 
|-
 
|-
 
|7.Description
 
|7.Description
 
|•Any remarks or description on the Account
 
|•Any remarks or description on the Account
 
|•Alphanumeric
 
|•Alphanumeric
 +
•Special Characters
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |None
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |100
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |No
 
|-
 
|-
 
|8.Debit
 
|8.Debit
 
|•Debit Amount for the Transaction
 
|•Debit Amount for the Transaction
 
|•Number
 
|•Number
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Any inputs aside numbers
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |20
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 
|-
 
|-
 
|9.Credit
 
|9.Credit
 
|•Credit Amount for the Transaction
 
|•Credit Amount for the Transaction
 
|•Number
 
|•Number
|}Notes:
+
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Any inputs aside numbers
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |20
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 +
|}<br />
 +
 
 +
Notes:
  
 
*Proforma should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
*Proforma should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
Line 121: Line 207:
 
*Journal Vouchers that are auto-generated from [[Payment Voucher]] cannot be edited.
 
*Journal Vouchers that are auto-generated from [[Payment Voucher]] cannot be edited.
 
*Only one user can use Edit Voucher function at a time.
 
*Only one user can use Edit Voucher function at a time.
*For detailed steps on how to edit a Journal Voucher, you can visit the Journal Voucher Job Aids which can be found [[Journal Voucher Aids|here]]
 
  
=====Journal Voucher Options=====
+
=====<span class="mw-headline" id="Printing_Petty_Cash" style="box-sizing: inherit;"><span class="mw-headline" id="Printing_Disbursement_Voucher" style="box-sizing: inherit;"><span class="mw-headline" id="Printing_Receipt_Voucher" style="box-sizing: inherit;"><span class="mw-headline" id="Printing_Payment_Voucher" style="box-sizing: inherit;"><span class="mw-headline" id="Printing_Accounts_Receivable" style="box-sizing: inherit;"><span class="mw-headline ve-pasteProtect" id="Editing_Import_Purchase_Order" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}" style="box-sizing: inherit;">Printing Journal Voucher</span></span></span></span></span></span>=====
[[File:Journal Voucher Options.png|center|thumb|Journal Voucher Options]]
+
 
 +
#Click [[Journal Voucher]] Voucher under Financials Menu
 +
#Select Journal Voucher that needs to print its details. Click the Drop-down Arrow then click Print'''.'''
  
*For detailed steps on how to Export and Import a Journal Voucher, you can visit the Journal Voucher Job Aids which can be found [[Journal Voucher Aids|here]]
+
[[File:Financials - Journal Voucher - Print.png|border|center|1500x1500px]]
 +
<br />
  
=====Journal Voucher Importing Option=====
+
=====<span class="mw-headline" id="Cancelling_Petty_Cash" style="box-sizing: inherit;"><span class="mw-headline" id="Cancelling_Disbursement_Voucher_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Cancelling_Receipt_Voucher_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Cancelling_Payment_Voucher_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Cancelling_Accounts_Receivable_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Cancelling_Purchase_Order_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Cancelling_Purchase_Order_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Cancelling_Purchase_Requisition_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Cancelling_Sales_Quotation_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_ATC_Code_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Item_Class_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Item_Type_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Deleting_Chart_of_Account_Record" style="box-sizing: inherit;">Cancelling Journal Voucher</span></span></span></span></span></span></span></span></span></span></span></span></span>=====
[[File:Journal Voucher Importing Options.png|center|thumb|Journal Voucher Importing Options]]
+
Journal Voucher can be canceled in two ways:
  
*For detailed steps on how to Import a Journal Voucher, you can visit the Journal Voucher Job Aids which can be found [[Journal Voucher Aids|here]]
+
*Using drop-down arrow of a record can be used in single record cancellation
  
=====Journal Voucher Record Options=====
+
[[File:Financials - Journal Voucher - Cancel1.png|border|center|1500x1500px]]
[[File:Journal Voucher Record Options.png|center|thumb|Journal Voucher Record Options]]Notes:
+
<br />
 +
 
 +
*Using Cancel Button for cancelling multiple records
 +
 
 +
[[File:Financials - Journal Voucher - Cancel2.png|border|center|1500x1500px]]
 +
<br />
 +
=====Importing and Exporting Journal Voucher=====
 +
1. Under Journal Voucher 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.
 +
 
 +
[[File:Financials - Journal Voucher - Export.png|border|center|1879x1879px]]
 +
<br />
  
*For detailed steps on how to View, Edit, Print and Cancel a Journal Voucher, you can visit the Journal Voucher Job Aids which can be found [[Journal Voucher Aids|here]]
+
*When Importing the records, the user should follow the following steps provided in the Importing Journal Voucher 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
  
=====Journal Voucher View Record=====
+
[[File:Financials - Journal Voucher - Import.png|border|center|1500x1500px]]
[[File:Journal Voucher View Record.png|center|thumb|Journal Voucher View Record]]
 
 
<br />
 
<br />
 +
{| 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;" |Import Data Dictionary of Journal 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
 +
!Character Limit
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Required Field?
 +
|- style="box-sizing: inherit;"
 +
| style="" |1.Document Set
 +
| style="" |Manual Entry of Document Set of Journal Voucher
 +
| style="" |*Alphanumeric
 +
<nowiki>*</nowiki>Underscore "_"
 +
| style="vertical-align:middle;text-align:center;" |Other Special characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |5
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |2.Transaction Date
 +
| style="" |Manual entry of Transaction Date of the Voucher
 +
| style="" |*Numeric
 +
<nowiki>*</nowiki>Dash "-"
  
*For detailed steps on how to View a Journal Voucher, you can visit the Journal Voucher Job Aids which can be found [[Journal Voucher Aids|here]]
+
<nowiki>*</nowiki>Backslash "\"
 +
| style="vertical-align:middle;text-align:center;" |Other Special characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |3.Reference No.
 +
| style="" |Manual Entry of Journal Voucher Reference No.
 +
| style="" |*Alphanumeric
 +
<nowiki>*</nowiki>Underscore "_"
  
{| class="wikitable"
+
<nowiki>*</nowiki>Dash "-"
 +
| style="vertical-align:middle;text-align:center;" |Other Special characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |50
 +
| style="vertical-align:middle;text-align:center;" |No
 +
|- style="box-sizing: inherit;"
 +
| style="" |4.Notes
 +
| style="" |Other remarks in the Journal Voucher
 +
| style="" |*Alphanumeric
 +
 
 +
<nowiki>*</nowiki>Underscore "_"
 +
 
 +
<nowiki>*</nowiki>Dash "-"
 +
| style="vertical-align:middle;text-align:center;" |Other Special characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |300
 +
| style="vertical-align:middle;text-align:center;" |No
 +
|- style="box-sizing: inherit;"
 +
| style="" |5.Account Name
 +
| style="" |Manual Entry of Account Name - must be based from [[Chart of Account]] Maintenance
 +
| style="" |*Numeric
 +
<nowiki>*</nowiki>Account Name based from [[Chart of Account]] Maintenance Module
 +
| style="vertical-align:middle;text-align:center;" |Any input not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |6.Description
 +
| style="" |Manual Entry of Account Description
 +
| style="" |*Alphanumeric
 +
<nowiki>*</nowiki>Special Characters
 +
| style="vertical-align:middle;text-align:center;" |*None
 +
| style="vertical-align:middle;text-align:center;" |100
 +
| style="vertical-align:middle;text-align:center;" |No
 +
|- style="box-sizing: inherit;"
 +
| style="" |7.Debit
 +
| style="" |Manual entry of Debit Amount
 +
| style="" |*Numeric
 +
| style="vertical-align:middle;text-align:center;" |Any input except numbers
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |8.Credit
 +
| style="" |Manual entry of Credit Amount
 +
| style="" |*Numeric
 +
| style="vertical-align:middle;text-align:center;" |Any input except numbers
 +
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|}
 +
 
 +
=====Journal Voucher Record Options=====
 +
{| 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 Journal Voucher 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;" |Print
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Post
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Unpost
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Cancel
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''UNPOSTED'''
 +
| 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="" |
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''POSTED'''
 +
| 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="vertical-align:middle;text-align:center;" |
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''CANCELLED'''
 +
| 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="" |
 +
| style="vertical-align:middle;text-align:center;" |
 +
|}
 +
Notes:
 +
 
 +
*Only Manually created Journal Vouchers can be edited
 +
**Manually created Journal Vouchers can be edited while viewing the record.
 +
*Any auto-generated Journal Voucher will set its status into '''POSTED'''
 +
 
 +
{| class="wikitable" style="margin: auto;"
 
|+Categories:
 
|+Categories:
 
! colspan="2" |'''Modules'''
 
! colspan="2" |'''Modules'''
 
|-
 
|-
 
|Financials
 
|Financials
|[[Financials]]<nowiki> | </nowiki>[[Journal Voucher]]<nowiki> | </nowiki>[[Depreciation Run]]
+
|[[Financials]]<nowiki> | </nowiki>[[Journal Voucher]]
 
|-
 
|-
 
|Inventory
 
|Inventory
Line 157: Line 378:
 
|[[Proforma]]<nowiki> | </nowiki>[[Chart of Account]]
 
|[[Proforma]]<nowiki> | </nowiki>[[Chart of Account]]
 
|-
 
|-
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
+
! colspan="2" |'''Report'''
|-
 
|Financials Aids
 
|[[Journal Voucher Aids]]<nowiki> | </nowiki>[[Depreciation Run Aids]]
 
|-
 
|Inventory Aids
 
|[[Purchase Return Aids]]<nowiki> | </nowiki>[[Sales Return Aids]]
 
 
|-
 
|-
|Maintenance Aids
+
|Financial Statements
|[[Proforma Aids]]<nowiki> | </nowiki>[[Chart of Accounts Aids]]
+
|[[General Journal]]
 
|}<br />
 
|}<br />
 +
[[Category:Financials]]
 +
[[Category:Inventory]]
 +
[[Category:Tax Reports]]
 +
[[Category:Financial Statements]]

Latest revision as of 12:54, 19 April 2022


Journal Voucher

Allows the user to create a voucher to be used for financial activity like sales return and purchase return.

Requirements before using Journal Voucher
Journal Voucher Record List
Financials - Journal Voucher - Record List.png


Adding Journal Voucher
  1. Click Journal Voucher Voucher under Financials Menu
  2. Under Journal Voucher Screen, Click Add Journal Voucher
  3. Fill out the necessary fields in the header section
  4. Fill out the necessary fields in the Accounting then Click Save
Financials - Journal Voucher - Add.png


Field Description Allowed Inputs Restricted Inputs Character Limit Required Field?
1.Voucher No. •Voucher Number of the Transaction upon creation •Alphanumeric(Auto-Generated) N/A N/A N/A
2.Reference No. •Reference Number of the Transaction •Alphanumeric

•Special Characters

None 50 Yes
3.Transaction Date •Date when the Transaction was Created •Date picker provided by system N/A N/A Yes
4.Proforma •Financial statements is to facilitate comparisons of historic data and projections of future performance. •Proforma list provided in the Proforma Maintenance Module N/A N/A No
5.Notes •Other Remarks on the Transaction •Alphanumeric

•Special Characters

None 300 No
6.Account •Account to be charged for credit and debit amount on the transaction •Account list in the Chart of Accounts Maintenance Module N/A N/A Yes
7.Description •Any remarks or description on the Account •Alphanumeric

•Special Characters

None 100 No
8.Debit •Debit Amount for the Transaction •Number Any inputs aside numbers 20 Yes
9.Credit •Credit Amount for the Transaction •Number Any inputs aside numbers 20 Yes

Notes:

  • Proforma should be on ACTIVE status when using it upon creating or editing a transaction.
    • This can be seen in Proforma Maintenance Module
    • Past Transactions with INACTIVE Proforma prior to its deactivation can still be used.
  • Account should be on ACTIVE status when using it upon creating or editing a transaction.
  • Journal Voucher is autogenerated when creating a Sales Return.
  • Journal Voucher is autogenerated when creating a Purchase Return.
  • Only one user can use Add Voucher function at a time.
Viewing Journal Voucher
  1. Click Journal Voucher Voucher under Financials Menu
  2. Select Journal Voucher that needs to view its details, click the drop-down arrow then choose View.
  3. The user has an option to Edit the Journal Voucher upon viewing it. The Journal can only be edit if the Voucher was created manually.
Financials - Journal Voucher - View.png


Editing Journal Voucher
  1. Click Journal Voucher Voucher under Financials Menu
  2. Select the Journal Voucher that needs to update its details, click the drop-down arrow then click Edit.
  3. Update the necessary the fields. Then click Save.
Financials - Journal Voucher - Edit.png
Field Description Allowed Inputs Restricted Inputs Character Limit Required Field?
1.Voucher No. •Voucher Number of the Transaction upon creation •Alphanumeric(Auto-Generated) N/A N/A N/A
2.Reference No. •Reference Number of the Transaction •Alphanumeric

•Special Characters

None 50 Yes
3.Transaction Date •Date when the Transaction was Created •Date picker provided by system N/A N/A Yes
4.Proforma •Financial statements is to facilitate comparisons of historic data and projections of future performance. •Proforma list provided in the Proforma Maintenance Module N/A N/A No
5.Notes •Other Remarks on the Transaction •Alphanumeric

•Special Characters

None 300 No
6.Account •Account to be charged for credit and debit amount on the transaction •Account list in the Chart of Accounts Maintenance Module N/A N/A Yes
7.Description •Any remarks or description on the Account •Alphanumeric

•Special Characters

None 100 No
8.Debit •Debit Amount for the Transaction •Number Any inputs aside numbers 20 Yes
9.Credit •Credit Amount for the Transaction •Number Any inputs aside numbers 20 Yes


Notes:

  • Proforma should be on ACTIVE status when using it upon creating or editing a transaction.
    • This can be seen in Proforma Maintenance Module
    • Past Transactions with INACTIVE Proforma prior to its deactivation can still be used.
  • Account should be on ACTIVE status when using it upon creating or editing a transaction.
  • When Sales Return record was updated, the Journal Voucher corresponds to it will also be updated.
  • Journal Vouchers that are auto-generated from Payment Voucher cannot be edited.
  • Only one user can use Edit Voucher function at a time.
Printing Journal Voucher
  1. Click Journal Voucher Voucher under Financials Menu
  2. Select Journal Voucher that needs to print its details. Click the Drop-down Arrow then click Print.
Financials - Journal Voucher - Print.png


Cancelling Journal Voucher

Journal Voucher can be canceled in two ways:

  • Using drop-down arrow of a record can be used in single record cancellation
Financials - Journal Voucher - Cancel1.png


  • Using Cancel Button for cancelling multiple records
Financials - Journal Voucher - Cancel2.png


Importing and Exporting Journal Voucher

1. Under Journal Voucher 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.
Financials - Journal Voucher - Export.png


  • When Importing the records, the user should follow the following steps provided in the Importing Journal Voucher 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
Financials - Journal Voucher - Import.png


Import Data Dictionary of Journal Voucher
Field Description of Data Output Allowed Inputs Input Restrictions Character Limit Required Field?
1.Document Set Manual Entry of Document Set of Journal Voucher *Alphanumeric

*Underscore "_"

Other Special characters not mentioned 5 Yes
2.Transaction Date Manual entry of Transaction Date of the Voucher *Numeric

*Dash "-"

*Backslash "\"

Other Special characters not mentioned N/A Yes
3.Reference No. Manual Entry of Journal Voucher Reference No. *Alphanumeric

*Underscore "_"

*Dash "-"

Other Special characters not mentioned 50 No
4.Notes Other remarks in the Journal Voucher *Alphanumeric

*Underscore "_"

*Dash "-"

Other Special characters not mentioned 300 No
5.Account Name Manual Entry of Account Name - must be based from Chart of Account Maintenance *Numeric

*Account Name based from Chart of Account Maintenance Module

Any input not mentioned in the allowed inputs N/A Yes
6.Description Manual Entry of Account Description *Alphanumeric

*Special Characters

*None 100 No
7.Debit Manual entry of Debit Amount *Numeric Any input except numbers N/A Yes
8.Credit Manual entry of Credit Amount *Numeric Any input except numbers N/A Yes
Journal Voucher Record Options
Actions Available base on Journal Voucher Record Status
Status View Edit Print Post Unpost Cancel
UNPOSTED
POSTED
CANCELLED

Notes:

  • Only Manually created Journal Vouchers can be edited
    • Manually created Journal Vouchers can be edited while viewing the record.
  • Any auto-generated Journal Voucher will set its status into POSTED
Categories:
Modules
Financials Financials | Journal Voucher
Inventory Purchase Return | Sales Return
Maintenance Proforma | Chart of Account
Report
Financial Statements General Journal