Difference between revisions of "Journal Voucher"

(Tag: 2017 source edit)
Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
[[Financials]] | [[Journal Voucher Aids]] | [[Depreciation Run]]
+
[[Financials]] | [[Inventory]]
 
</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]]
+
=====Adding Journal Voucher=====
 +
 
 +
# Go to Financials then click [[Journal Voucher]]
 +
# Click '''Add Journal Voucher''' Button
 +
# Fill out the necessary fields on the Journal Voucher Header Form.
 +
# Fill out the Accounting Details of the Journal Voucher Form then Click '''Save'''
  
=====Adding Journal Voucher=====
 
[[File:Adding Journal Voucher.png|center|thumb|863x863px|Adding Journal Voucher]]
 
 
{| class="wikitable"
 
{| class="wikitable"
 +
!Field
 +
!Description
 +
!Expected Values
 +
|-
 
|1.Voucher No.
 
|1.Voucher No.
 
|•Voucher Number of the Transaction upon creation
 
|•Voucher Number of the Transaction upon creation
Line 31: Line 35:
 
|•Date
 
|•Date
 
|-
 
|-
|4.[[Proforma]]
+
|4.[https://docs.oojeema.com/Proforma 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
Line 39: Line 43:
 
|•Alphanumeric
 
|•Alphanumeric
 
|-
 
|-
|6.[[Chart of Account|Account]]
+
|6.[https://docs.oojeema.com/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
Line 61: Line 65:
 
*<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]]
 
  
 
=====Editing Journal Voucher=====
 
=====Editing Journal Voucher=====
[[File:Editing Journal Voucher.png|center|thumb|861x861px|Editing Journal Voucher]]
+
 
<br />
+
# Go to Financials then click [[Journal Voucher]]
 +
# Select the Journal Voucher that needs an edit, click the drop-down arrow then choose '''Edit.'''
 +
# Update the necessary the fields. Then click '''Save.'''
 +
 
 
{| class="wikitable"
 
{| class="wikitable"
 
!Field
 
!Field
Line 121: Line 126:
 
*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=====
+
=====Importing and Exporting Journal Voucher=====
[[File:Journal Voucher Options.png|center|thumb|Journal Voucher Options]]
+
1. Under Journal Voucher Screen, Click Options
  
*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]]
+
2. Under Options, The user may Export or Import The Record
  
=====Journal Voucher Importing Option=====
+
* 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:Journal Voucher Importing Options.png|center|thumb|Journal Voucher Importing Options]]
+
* 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
  
*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]]
+
{| 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
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Required (Y/N)
 +
|- style="box-sizing: inherit;"
 +
| style="" |1.Document Set
 +
| style="" |Manual Entry of Document Set of Journal Voucher
 +
| style="" |*Alphanumeric
 +
<nowiki>*</nowiki>Underscore "_"
 +
| style="" |*Other Special characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |Y
 +
|- style="box-sizing: inherit;"
 +
| style="" |2.Transaction Date
 +
| style="" |Manual entry of Transaction Date of the Voucher
 +
| style="" |*Numeric
 +
<nowiki>*</nowiki>Dash "-"
  
=====Journal Voucher Record Options=====
+
<nowiki>*</nowiki>Backslash "\"
[[File:Journal Voucher Record Options.png|center|thumb|Journal Voucher Record Options]]Notes:
+
| style="" |*Other Special characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |Y
 +
|- style="box-sizing: inherit;"
 +
| style="" |3.Reference No.
 +
| style="" |Manual Entry of Accounts Payable Reference No.
 +
| style="" |*Alphanumeric
 +
<nowiki>*</nowiki>Underscore "_"
 +
 
 +
<nowiki>*</nowiki>Dash "-"
 +
| style="" |*Other Special characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |N
 +
|- style="box-sizing: inherit;"
 +
| style="" |4.Notes
 +
| style="" |Manual Entry of Journal Voucher Reference No.
 +
| style="" |*Alphanumeric
 +
 
 +
<nowiki>*</nowiki>Underscore "_"
  
*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]]
+
<nowiki>*</nowiki>Dash "-"
 +
| style="" |*Other Special characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |N
 +
|- 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="" |*Any input not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |Y
 +
|- style="box-sizing: inherit;"
 +
| style="" |6.Description
 +
| style="" |Manual Entry of Account Description
 +
| style="" |*Alphanumeric
 +
<nowiki>*</nowiki>Special Characters
 +
| style="" |*None
 +
| style="vertical-align:middle;text-align:center;" |N
 +
|- style="box-sizing: inherit;"
 +
| style="" |7.Debit
 +
| style="" |Manual entry of Debit Amount
 +
| style="" |*Numeric
 +
| style="" |*Any input except numbers
 +
| style="vertical-align:middle;text-align:center;" |Y
 +
|- style="box-sizing: inherit;"
 +
| style="" |8.Credit
 +
| style="" |Manual entry of Credit Amount
 +
| style="" |*Numeric
 +
| style="" |*Any input except numbers
 +
| style="vertical-align:middle;text-align:center;" |Y
 +
|}
  
=====Journal Voucher View Record=====
+
=====Journal Voucher Record Options=====
[[File:Journal Voucher View Record.png|center|thumb|Journal Voucher View Record]]
+
{| 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;"
<br />
+
|+ 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="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:
  
*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]]
+
*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"
+
{| 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 156: Line 261:
 
|Maintenance
 
|Maintenance
 
|[[Proforma]]<nowiki> | </nowiki>[[Chart of Account]]
 
|[[Proforma]]<nowiki> | </nowiki>[[Chart of Account]]
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
|-
 
|Financials Aids
 
|[[Journal Voucher Aids]]<nowiki> | </nowiki>[[Depreciation Run Aids]]
 
|-
 
|Inventory Aids
 
|[[Purchase Return Aids]]<nowiki> | </nowiki>[[Sales Return Aids]]
 
|-
 
|Maintenance Aids
 
|[[Proforma Aids]]<nowiki> | </nowiki>[[Chart of Accounts Aids]]
 
 
|}<br />
 
|}<br />

Revision as of 13:02, 21 December 2021


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
Adding Journal Voucher
  1. Go to Financials then click Journal Voucher
  2. Click Add Journal Voucher Button
  3. Fill out the necessary fields on the Journal Voucher Header Form.
  4. Fill out the Accounting Details of the Journal Voucher Form then Click Save
Field Description Expected Values
1.Voucher No. •Voucher Number of the Transaction upon creation •Alphanumeric(Auto-Generated)
2.Reference No. •Reference Number of the Transaction •Alphanumeric
3.Transaction Date •Date when the Transaction was Created •Date
4.Proforma •Financial statements is to facilitate comparisons of historic data and projections of future performance. •Proforma list provided in the Proforma Maintenance Module
5.Notes •Other Remarks on the Transaction •Alphanumeric
6.Account •Account to be charged for credit and debit amount on the transaction •Account list in the Chart of Accounts Maintenance Module
7.Description •Any remarks or description on the Account •Alphanumeric
8.Debit •Debit Amount for the Transaction •Number
9.Credit •Credit Amount for the Transaction •Number

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.
Editing Journal Voucher
  1. Go to Financials then click Journal Voucher
  2. Select the Journal Voucher that needs an edit, click the drop-down arrow then choose Edit.
  3. Update the necessary the fields. Then click Save.
Field Description Expected Values
1.Voucher No. •Voucher Number of the Transaction upon creation •Alphanumeric(Auto-Generated)
2.Reference No. •Reference Number of the Transaction •Alphanumeric
3.Transaction Date •Date when the Transaction was Created •Date
4.Proforma •Financial statements is to facilitate comparisons of historic data and projections of future performance. •Proforma list provided in the Proforma Maintenance Module
5.Notes •Other Remarks on the Transaction •Alphanumeric
6.Account •Account to be charged for credit and debit amount on the transaction •Account list in the Chart of Accounts Maintenance Module
7.Description •Any remarks or description on the Account •Alphanumeric
8.Debit •Debit Amount for the Transaction •Number
9.Credit •Credit Amount for the Transaction •Number

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.
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.
  • 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
Import Data Dictionary of Journal Voucher
Field Description of Data Output Allowed Inputs Input Restrictions Required (Y/N)
1.Document Set Manual Entry of Document Set of Journal Voucher *Alphanumeric

*Underscore "_"

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

*Dash "-"

*Backslash "\"

*Other Special characters not mentioned Y
3.Reference No. Manual Entry of Accounts Payable Reference No. *Alphanumeric

*Underscore "_"

*Dash "-"

*Other Special characters not mentioned N
4.Notes Manual Entry of Journal Voucher Reference No. *Alphanumeric

*Underscore "_"

*Dash "-"

*Other Special characters not mentioned N
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 Y
6.Description Manual Entry of Account Description *Alphanumeric

*Special Characters

*None N
7.Debit Manual entry of Debit Amount *Numeric *Any input except numbers Y
8.Credit Manual entry of Credit Amount *Numeric *Any input except numbers Y
Journal Voucher Record Options
Actions Available base on Disbursement 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