Difference between revisions of "Journal Voucher"

 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
[[Financials]] | [[Inventory]]
+
[[Financials]] | [[Inventory]] | [[General Journal]]
 
</div><br />
 
</div><br />
 
==Journal Voucher==
 
==Journal Voucher==
Line 11: Line 11:
  
 
=====Journal Voucher Record List=====
 
=====Journal Voucher Record List=====
 +
[[File:Financials - Journal Voucher - Record List.png|border|center|1500x1500px]]
 +
<br />
 
=====Adding Journal Voucher=====
 
=====Adding Journal Voucher=====
  
#Go to Financials then click [[Journal Voucher]]
+
#Click [[Journal Voucher]] Voucher under Financials Menu
#Click '''Add Journal Voucher''' Button
+
#Under Journal Voucher Screen, Click '''Add Journal Voucher'''
#Fill out the necessary fields on the Journal Voucher Header Form.
+
#Fill out the necessary fields in the header section
#Fill out the Accounting Details of the Journal Voucher Form then Click '''Save'''
+
#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
+
!'''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;" |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.[https://docs.oojeema.com/Proforma 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.[https://docs.oojeema.com/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 69: Line 106:
 
*Only one user can use Add Voucher function at a time.
 
*Only one user can use Add Voucher function at a time.
  
 +
=====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=====
  
#Go to Financials then click [[Journal Voucher]]
+
#Click [[Journal Voucher]] Voucher under Financials Menu
#Select the Journal Voucher that needs an edit, click the drop-down arrow then choose '''Edit.'''
+
#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.'''
 
#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 127: Line 208:
 
*Only one user can use Edit Voucher function at a time.
 
*Only one user can use Edit Voucher function at a time.
  
 +
=====<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>=====
 +
 +
#Click [[Journal Voucher]] Voucher under Financials Menu
 +
#Select Journal Voucher that needs to print its details. Click the Drop-down Arrow then click Print'''.'''
 +
 +
[[File:Financials - Journal Voucher - Print.png|border|center|1500x1500px]]
 +
<br />
 +
 +
=====<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>=====
 +
Journal Voucher can be canceled in two ways:
 +
 +
*Using drop-down arrow of a record can be used in single record cancellation
 +
 +
[[File:Financials - Journal Voucher - Cancel1.png|border|center|1500x1500px]]
 +
<br />
 +
 +
*Using Cancel Button for cancelling multiple records
 +
 +
[[File:Financials - Journal Voucher - Cancel2.png|border|center|1500x1500px]]
 +
<br />
 
=====Importing and Exporting Journal Voucher=====
 
=====Importing and Exporting Journal Voucher=====
 
1. Under Journal Voucher Screen, Click Options
 
1. Under Journal Voucher Screen, Click Options
Line 133: Line 234:
  
 
*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.
 +
 +
[[File:Financials - Journal Voucher - Export.png|border|center|1879x1879px]]
 +
<br />
 +
 
*When Importing the records, the user should follow the following steps provided in the Importing Journal Voucher Screen such as
 
*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.
 
**Downloading the template link provided under Step 1.
Line 138: Line 243:
 
**Uploading the updated Template
 
**Uploading the updated Template
  
 +
[[File:Financials - Journal Voucher - Import.png|border|center|1500x1500px]]
 +
<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;"
 
{| 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="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
Line 144: Line 251:
 
! style="background-color:rgb(234, 236, 240);text-align:center;" |Allowed Inputs
 
! 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;" |Input Restrictions
! style="background-color:rgb(234, 236, 240);text-align:center;" |Required (Y/N)
+
!Character Limit
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Required Field?
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| style="" |1.Document Set
 
| style="" |1.Document Set
Line 150: Line 258:
 
| style="" |*Alphanumeric
 
| style="" |*Alphanumeric
 
<nowiki>*</nowiki>Underscore "_"
 
<nowiki>*</nowiki>Underscore "_"
| style="" |*Other Special characters not mentioned
+
| style="vertical-align:middle;text-align:center;" |Other Special characters not mentioned
| style="vertical-align:middle;text-align:center;" |Y
+
| style="vertical-align:middle;text-align:center;" |5
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| style="" |2.Transaction Date
 
| style="" |2.Transaction Date
Line 159: Line 268:
  
 
<nowiki>*</nowiki>Backslash "\"
 
<nowiki>*</nowiki>Backslash "\"
| style="" |*Other Special characters not mentioned
+
| style="vertical-align:middle;text-align:center;" |Other Special characters not mentioned
| style="vertical-align:middle;text-align:center;" |Y
+
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| style="" |3.Reference No.
 
| style="" |3.Reference No.
Line 168: Line 278:
  
 
<nowiki>*</nowiki>Dash "-"
 
<nowiki>*</nowiki>Dash "-"
| style="" |*Other Special characters not mentioned
+
| style="vertical-align:middle;text-align:center;" |Other Special characters not mentioned
| style="vertical-align:middle;text-align:center;" |N
+
| style="vertical-align:middle;text-align:center;" |50
 +
| style="vertical-align:middle;text-align:center;" |No
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| style="" |4.Notes
 
| style="" |4.Notes
Line 178: Line 289:
  
 
<nowiki>*</nowiki>Dash "-"
 
<nowiki>*</nowiki>Dash "-"
| style="" |*Other Special characters not mentioned
+
| style="vertical-align:middle;text-align:center;" |Other Special characters not mentioned
| style="vertical-align:middle;text-align:center;" |N
+
| style="vertical-align:middle;text-align:center;" |300
 +
| style="vertical-align:middle;text-align:center;" |No
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| style="" |5.Account Name
 
| style="" |5.Account Name
Line 185: Line 297:
 
| style="" |*Numeric
 
| style="" |*Numeric
 
<nowiki>*</nowiki>Account Name based from [[Chart of Account]] Maintenance Module
 
<nowiki>*</nowiki>Account Name based from [[Chart of Account]] Maintenance Module
| style="" |*Any input not mentioned in the allowed inputs
+
| style="vertical-align:middle;text-align:center;" |Any input not mentioned in the allowed inputs
| style="vertical-align:middle;text-align:center;" |Y
+
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| style="" |6.Description
 
| style="" |6.Description
Line 192: Line 305:
 
| style="" |*Alphanumeric
 
| style="" |*Alphanumeric
 
<nowiki>*</nowiki>Special Characters
 
<nowiki>*</nowiki>Special Characters
| style="" |*None
+
| style="vertical-align:middle;text-align:center;" |*None
| style="vertical-align:middle;text-align:center;" |N
+
| style="vertical-align:middle;text-align:center;" |100
 +
| style="vertical-align:middle;text-align:center;" |No
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| style="" |7.Debit
 
| style="" |7.Debit
 
| style="" |Manual entry of Debit Amount
 
| style="" |Manual entry of Debit Amount
 
| style="" |*Numeric
 
| style="" |*Numeric
| style="" |*Any input except numbers
+
| style="vertical-align:middle;text-align:center;" |Any input except numbers
| style="vertical-align:middle;text-align:center;" |Y
+
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| style="" |8.Credit
 
| style="" |8.Credit
 
| style="" |Manual entry of Credit Amount
 
| style="" |Manual entry of Credit Amount
 
| style="" |*Numeric
 
| style="" |*Numeric
| style="" |*Any input except numbers
+
| style="vertical-align:middle;text-align:center;" |Any input except numbers
| style="vertical-align:middle;text-align:center;" |Y
+
| style="vertical-align:middle;text-align:center;" |N/A
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|}
 
|}
  
 
=====Journal Voucher Record Options=====
 
=====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;"
 
{| 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 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 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;" |Status
 
! style="background-color:rgb(234, 236, 240);text-align:center;" |View
 
! style="background-color:rgb(234, 236, 240);text-align:center;" |View
Line 261: Line 377:
 
|Maintenance
 
|Maintenance
 
|[[Proforma]]<nowiki> | </nowiki>[[Chart of Account]]
 
|[[Proforma]]<nowiki> | </nowiki>[[Chart of Account]]
 +
|-
 +
! colspan="2" |'''Report'''
 +
|-
 +
|Financial Statements
 +
|[[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