Difference between revisions of "Sales Journal"

(Changed categories.)
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div style="text-align: center;">[[Tax Reports]] | [[Sales Journal]]<nowiki> | </nowiki>[[Purchase Journal]]<nowiki> | </nowiki>[[VAT Summary]]<nowiki> | </nowiki>[[BIR Form 2550M]]<nowiki> | </nowiki>[[BIR Form 2550Q]]<nowiki> | </nowiki>[[BIR Form 2551Q]]<nowiki> | </nowiki>[[BIR Form 0619-E]]<nowiki> | </nowiki>[[BIR Form 1601E-Q]]<nowiki> | </nowiki>[[BIR Form 1604E]]<nowiki> | </nowiki>[[Sales Relief]]<nowiki> | </nowiki>[[Purchase Relief]]<nowiki> | </nowiki>[[SAWT|Summary Alphalist of Withholding Tax]]</div>
+
<div style="text-align: center;">[[Tax Reports]] | [[Sales Journal]]</div>
  
 
==Sales Journal==
 
==Sales Journal==
  
======Sales Journal Menu List======
+
=====Sales Journal Menu List=====
[[File:Sales Journal Menu List.png|center|thumb|1050x1050px|Sales Journal Menu List]]
+
[[File:Tax Reports - Sales Journal - Record List.png|border|center|1500x1500px]]
 +
 
 +
 
 
'''Sales Journal''' refers to the <span style="color: rgb(51, 51, 51)">Report for the recording of the sales on credit to customers(Customer's Receivables)</span>
 
'''Sales Journal''' refers to the <span style="color: rgb(51, 51, 51)">Report for the recording of the sales on credit to customers(Customer's Receivables)</span>
  
Sales Journal Menu Terms on Oojeema Prime System
+
=====<span class="mw-headline" id="Requirements_before_using_Returns_per_Customer" style="box-sizing: inherit;"><span class="mw-headline" id="Requirements_before_using_Sales_Report" style="box-sizing: inherit;"><span class="mw-headline" id="Requirements_before_using_AR_Detailed_Report" style="box-sizing: inherit;"><span class="mw-headline" id="Requirements_before_using_Accounts_Receivable_Aging" style="box-sizing: inherit;"><span class="mw-headline" id="Requirements_before_using_Sales_Quotation" style="box-sizing: inherit;">Requirements before using Sales Journal</span></span></span></span></span>=====
 +
 
 +
*The user should setup have the following records in order to proceed on using the Sales Journal
 +
**[[Customer]]
 +
**[[Sales Invoice]]
  
#'''Record Filter'''(Date Range, Customer) - Set of record filters for precise searching of records.  
+
{| class="wikitable" style="margin: auto;"
#*Date Range will be automatically set as the Current Month by default
+
|+Sales Journal Menu Terms on Oojeema Prime System
#*Customer will be automatically be set as Filter: All by default
+
!Field
#'''Date''' - Date of the Transaction
+
!Description
#'''Customer's TIN''' - TIN number of the Customer
+
|-
#'''Customer's Name''' - Name of the Customer
+
|1. '''Record Filter'''(Date Range, Customer)
#'''Description''' - Any remarks on the Transaction/Invoice.
+
|Set of record filters for precise searching of records.
#'''Reference No.''' - Reference No of the [[Sales Invoice]]
+
 
#'''Amount''' - Amount in the Invoice.
+
*Date Range will be automatically set as the Current Month by default
#*Discounts and other computations is already applied on this Amount.
+
*Customer will be automatically be set as Filter: All by default
#'''Discount Amount''' - Discount amount applied on the Transaction.
+
|-
#'''VAT Amount''' - Tax Amount Applied on the Transaction
+
|2. '''Export'''
#'''Net Sales''' - Amount accumulated from sales after VAT is Applied.
+
|Allows the user to export the records in the report.
 +
|-
 +
|3. '''Date'''
 +
|Date of the Transaction
 +
|-
 +
|4. '''Customer's TIN'''
 +
|TIN number of the [[Customer]]
 +
|-
 +
|5. '''Customer's Name'''
 +
|Name of the [[Customer]]
 +
|-
 +
|6. '''Description'''
 +
|Any remarks on the Transaction/Invoice.
 +
|-
 +
|7. '''Reference No.'''
 +
|Reference No of the [[Sales Invoice]]
 +
|-
 +
|8. '''Amount'''
 +
|Amount in the Invoice.
  
 +
*Discounts and other computations is already applied on this Amount.
 +
|-
 +
|9. '''Discount Amount'''
 +
|Discount amount applied on the Transaction.
 +
|-
 +
|10. '''VAT Amount'''
 +
|Value Added Tax Amount Applied on the Transaction
 +
|-
 +
|11. '''Net Sales'''
 +
|Amount Accumulated with VAT
 +
|}
 
Notes:
 
Notes:
  
* <br />
+
*Customer must be '''ACTIVE''' status in order to View its Records in the Filter.
 +
**Customer status can be seen in [[Customer]] Maintenance Module<br />
 +
 
 +
=====<span class="mw-headline" id="Exporting_Sales_Journal" style="box-sizing: inherit;">Exporting Sales Journal</span>=====
  
======Sales Journal View Reference No.======
+
#Click [[Reports]] under Main Menu
[[File:Sales Journal View Reference.png|center|thumb|1000x1000px|Sales Journal View Reference]]
+
#Under Reports Page, Click '''[[Sales Journal]]''' under [[Tax Reports]] section.
{| 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: 1em 0px; 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;"
+
#Under Sales Journal, click the Export Button on the right side. Take note that you can filter the Date and Customer for precise exportation of records.
 +
 
 +
[[File:Tax Reports - Sales Journal - Export.png|border|center|1615x1615px]]
 +
<br />
 +
=====<span class="mw-headline" id="Viewing_Reference_Voucher_on_Sales_Journal" style="box-sizing: inherit;">Viewing Reference Voucher on Sales Journal</span>=====
 +
 
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports Menu, Click '''[[Sales Journal]]''' under [[Tax Reports]].
 +
#Under [[Sales Journal]], you can check the following linked voucher in the Reference No. column. Clicking the voucher will redirect you to View mode of the Voucher.
 +
 
 +
[[File:Tax Reports - Sales Journal - View.png|border|center|2203x2203px]]
 +
<br />
 +
{| class="wikitable" style="margin: auto;"
 
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" |Categories:
 
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" |Categories:
 
! colspan="2" style="background-color:rgb(234, 236, 240);text-align:center;" |'''Modules'''
 
! colspan="2" style="background-color:rgb(234, 236, 240);text-align:center;" |'''Modules'''
Line 35: Line 85:
 
| style="" |Sales
 
| style="" |Sales
 
| style="" |[[Sales Invoice]]
 
| style="" |[[Sales Invoice]]
 +
|-
 +
|Billing
 +
|[[Billing]]
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| style="" |Maintenance
 
| style="" |Maintenance
 
| style="" |[[Customer]]<nowiki> | </nowiki>[[Tax]]
 
| style="" |[[Customer]]<nowiki> | </nowiki>[[Tax]]
|- style="box-sizing: inherit;"
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
|- style="box-sizing: inherit;"
 
| style="" |Sales Aids
 
| style="" |[[Sales Invoice]]
 
|- style="box-sizing: inherit;"
 
| style="" |Maintenance Aids
 
| style="" |[[Customer Aids]]<nowiki> | </nowiki>[[Tax Aids]]
 
 
|-
 
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Module([[Reports]])'''
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Module([[Reports]])'''
Line 54: Line 99:
 
|Tax Reports
 
|Tax Reports
 
|[[Sales Journal]]<nowiki> | </nowiki>[[Purchase Journal]]<nowiki> | </nowiki>[[VAT Summary]]<nowiki> | </nowiki>[[BIR Form 2550M]]<nowiki> | </nowiki>[[BIR Form 2550Q]]<nowiki> | </nowiki>[[BIR Form 2551Q]]<nowiki> | </nowiki>[[BIR Form 0619-E]]<nowiki> | </nowiki>[[BIR Form 1601E-Q]]<nowiki> | </nowiki>[[BIR Form 1604E]]<nowiki> | </nowiki>[[Sales Relief]]<nowiki> | </nowiki>[[Purchase Relief]]<nowiki> | </nowiki>[[SAWT|Summary Alphalist of Withholding Tax]]
 
|[[Sales Journal]]<nowiki> | </nowiki>[[Purchase Journal]]<nowiki> | </nowiki>[[VAT Summary]]<nowiki> | </nowiki>[[BIR Form 2550M]]<nowiki> | </nowiki>[[BIR Form 2550Q]]<nowiki> | </nowiki>[[BIR Form 2551Q]]<nowiki> | </nowiki>[[BIR Form 0619-E]]<nowiki> | </nowiki>[[BIR Form 1601E-Q]]<nowiki> | </nowiki>[[BIR Form 1604E]]<nowiki> | </nowiki>[[Sales Relief]]<nowiki> | </nowiki>[[Purchase Relief]]<nowiki> | </nowiki>[[SAWT|Summary Alphalist of Withholding Tax]]
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Aid'''
 
|-
 
|Tax Reports
 
|[[Sales Journal Aids]]<nowiki> | </nowiki>[[Purchase Journal Aids]]<nowiki> | </nowiki>[[VAT Summary Aids]]<nowiki> | </nowiki>[[BIR Form 2550M Aids]]<nowiki> | </nowiki>[[BIR Form 2550Q Aids]]<nowiki> | </nowiki>[[BIR Form 0619-E Aids]]<nowiki> | </nowiki>[[BIR Form 1601E-Q Aids]]<nowiki> | </nowiki>[[BIR Form 1604E Aids]]<nowiki> | </nowiki>[[Sales Relief Aids]]<nowiki> | </nowiki>[[Purchase Relief Aids]]<nowiki> | </nowiki>[[SAWT Aids|Summary Alphalist of Withholding Taxes Aids]]
 
 
|}
 
|}
 +
[[Category:Tax Reports]]
 +
[[Category:Sales]]
 +
[[Category:Financials]]
 +
[[Category:Billing]]

Latest revision as of 14:41, 7 April 2022

Sales Journal

Sales Journal Menu List
Tax Reports - Sales Journal - Record List.png


Sales Journal refers to the Report for the recording of the sales on credit to customers(Customer's Receivables)

Requirements before using Sales Journal
  • The user should setup have the following records in order to proceed on using the Sales Journal
Sales Journal Menu Terms on Oojeema Prime System
Field Description
1. Record Filter(Date Range, Customer) Set of record filters for precise searching of records.
  • Date Range will be automatically set as the Current Month by default
  • Customer will be automatically be set as Filter: All by default
2. Export Allows the user to export the records in the report.
3. Date Date of the Transaction
4. Customer's TIN TIN number of the Customer
5. Customer's Name Name of the Customer
6. Description Any remarks on the Transaction/Invoice.
7. Reference No. Reference No of the Sales Invoice
8. Amount Amount in the Invoice.
  • Discounts and other computations is already applied on this Amount.
9. Discount Amount Discount amount applied on the Transaction.
10. VAT Amount Value Added Tax Amount Applied on the Transaction
11. Net Sales Amount Accumulated with VAT

Notes:

  • Customer must be ACTIVE status in order to View its Records in the Filter.
    • Customer status can be seen in Customer Maintenance Module
Exporting Sales Journal
  1. Click Reports under Main Menu
  2. Under Reports Page, Click Sales Journal under Tax Reports section.
  3. Under Sales Journal, click the Export Button on the right side. Take note that you can filter the Date and Customer for precise exportation of records.
Tax Reports - Sales Journal - Export.png


Viewing Reference Voucher on Sales Journal
  1. Click Reports under Main Menu
  2. Under Reports Menu, Click Sales Journal under Tax Reports.
  3. Under Sales Journal, you can check the following linked voucher in the Reference No. column. Clicking the voucher will redirect you to View mode of the Voucher.
Tax Reports - Sales Journal - View.png


Categories:
Modules
Sales Sales Invoice
Billing Billing
Maintenance Customer | Tax
Reports Module(Reports)
Reports Tax Reports
Tax Reports Sales Journal | Purchase Journal | VAT Summary | BIR Form 2550M | BIR Form 2550Q | BIR Form 2551Q | BIR Form 0619-E | BIR Form 1601E-Q | BIR Form 1604E | Sales Relief | Purchase Relief | Summary Alphalist of Withholding Tax