Difference between revisions of "Accounts Receivable"

(Tag: 2017 source edit)
Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
[[Financials]] | [[Accounts Receivable Aids]] | [[Receipt Voucher]]
+
[[Financials]] | [[Receipt Voucher]] | [[Sales Invoice]]
 
</div>
 
</div>
 
==Accounts Receivable==
 
==Accounts Receivable==
Line 132: Line 132:
 
=====Importing and Exporting Accounts Receivable=====
 
=====Importing and Exporting Accounts Receivable=====
  
# Under Accounts Receivable Screen, Click Options
+
#Under Accounts Receivable Screen, Click Options
# Under Options, the user may Export or Import Accounts Receivable
+
#Under Options, the user may Export or Import Accounts Receivable
#* When Exporting the records, the user may also use the filter options such as Date Filter, Search Bar and Customer 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 Customer filter for precise searching and exporting of records.
#* For batch creation, under Accounts Receivable menu, click options then choose Import Accounts Receivable button
+
#*For batch creation, under Accounts Receivable menu, click options then choose Import Accounts Receivable button
#** Download the Template provided in the Step 1
+
#**Download the Template provided in the Step 1
#** Fill up the information needed for each column of the template
+
#**Fill up the information needed for each column of the template
#** Upload the updated template then click Import to Proceed
+
#**Upload the updated template then click Import to Proceed
 +
 
 +
<br />
 +
{| class="wikitable"
 +
|+Accounts Receivable Import Fields
 +
!'''Field'''
 +
!'''Description of Data Output'''
 +
!'''Allowed Inputs'''
 +
!'''Input Restrictions'''
 +
!'''Required (Y/N)'''
 +
|-
 +
|1. Document Set
 +
|Manual entry of Document Set of Accounts Receivable (e.g., 1, 2, 3, A, B, C)
 +
|*Alphanumeric
 +
<nowiki>*</nowiki>Underscore (_)
 +
|*Other special characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |Y
 +
|-
 +
|2. Transaction Date
 +
|Manual entry of Transaction Date of Accounts Receivable
 +
|*Numeric
 +
<nowiki>*</nowiki>Dash (-), Backslash (/)
 +
|*Other special characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |Y
 +
|-
 +
|3. Due Date
 +
|Manual entry of Due Date of Accounts Receivable – must be based on Customer’s payment terms
 +
|*Numeric
 +
<nowiki>*</nowiki>Dash (-), Backslash (/)
 +
|*Other special characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |Y
 +
|-
 +
|4. Customer Code
 +
|Manual entry of Customer code – must be based from Customer Data maintenance
 +
|*Numeric
 +
<nowiki>*</nowiki> Customer Code based from Customer maintenance
 +
|*Any input not mentioned  in the required inputs
 +
| style="vertical-align:middle;text-align:center;" |Y
 +
|-
 +
|5. Invoice No.
 +
|Manual entry of Accounts Receivable Invoice No.
 +
|*Alphanumeric
 +
<nowiki>*</nowiki>Underscore (_), Dash (-)
 +
|*Other special characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |N
 +
|-
 +
|6. Reference No.
 +
|Manual entry of Accounts Receivable Reference No.
 +
|*Alphanumeric
 +
<nowiki>*</nowiki>Underscore (_), Dash (-)
 +
|*Other special characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |N
 +
|-
 +
|7. Notes
 +
|Manual entry of Accounts Receivable Notes
 +
|*Alphanumeric
 +
<nowiki>*</nowiki>Underscore (_), Dash (-)
 +
|*Other special characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |N
 +
|-
 +
|8. Account Code
 +
|Manual entry of Account Code – must be based from Chart of Accounts maintenance
 +
|*Numeric
 +
<nowiki>*</nowiki>Account Code based from Chart of Accounts maintenance
 +
|*Any input not mentioned  in the required inputs
 +
| style="vertical-align:middle;text-align:center;" |Y
 +
|-
 +
|9. Description
 +
|Manual entry of Account Description
 +
|*Alphanumeric
 +
<nowiki>*</nowiki>Special Characters
 +
|*None
 +
| style="vertical-align:middle;text-align:center;" |N
 +
|-
 +
|10. Debit
 +
|Manual entry of Debit amount
 +
|*Numeric
 +
|*Any input excepts numbers
 +
| style="vertical-align:middle;text-align:center;" |Y
 +
|-
 +
|11. Credit
 +
|Manual entry of Credit amount
 +
|*Numeric
 +
|*Any input excepts numbers
 +
| style="vertical-align:middle;text-align:center;" |Y
 +
|}
  
 
=====Accounts Receivable Record Option=====
 
=====Accounts Receivable Record Option=====
Line 199: Line 284:
 
|-
 
|-
 
|Financials
 
|Financials
|[[Accounts Receivable]]<nowiki> | </nowiki>[[Receipt Voucher]]<nowiki> | </nowiki>[[Financials]]
+
|[[Financials]]<nowiki> | </nowiki>[[Accounts Receivable]]<nowiki> | </nowiki>[[Receipt Voucher]]
 
|-
 
|-
 
|Sales
 
|Sales
 
|[[Delivery Receipt]]<nowiki> | </nowiki>[[Sales Invoice]]
 
|[[Delivery Receipt]]<nowiki> | </nowiki>[[Sales Invoice]]
|-
 
|Billing
 
|[[Billing]]
 
 
|-
 
|-
 
|Maintenance
 
|Maintenance
Line 211: Line 293:
 
|-
 
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
|-
 
|Financials Aids
 
|[[Accounts Receivable Aids]]<nowiki> | </nowiki>[[Receipt Voucher Aids]]
 
|-
 
|Sales Aids
 
|[[Delivery Receipt Aids]]<nowiki> | </nowiki>[[Sales Invoice Aids]]
 
|-
 
|Billing Aids
 
|[[Billing Aids]]
 
 
|-
 
|-
 
|Maintenance Aids
 
|Maintenance Aids
 
|[[Customer Aids]]<nowiki> | </nowiki>[[Proforma Aids]]<nowiki> | </nowiki>[[Chart of Accounts Aids]]<nowiki> | </nowiki>[[Tax Aids]]
 
|[[Customer Aids]]<nowiki> | </nowiki>[[Proforma Aids]]<nowiki> | </nowiki>[[Chart of Accounts Aids]]<nowiki> | </nowiki>[[Tax Aids]]
 
|}
 
|}

Revision as of 10:18, 26 November 2021

Accounts Receivable

Allows the user to create a transaction for the balance due to a firm for goods and services delivered or used but not yet paid for by customers.

Requirements before using Accounts Receivable
Accounts Receivable Record Status
Status Description
UNPAID If the Accounts Receivable has been created
POSTED If the Accounts Receivable is Posted and ready to receive its payment
WITH PARTIAL PAYMENT If the Accounts Receivable is Paid Partially
PAID If the Accounts Receivable is completely Paid
CANCELLED If the Accounts Receivable is cancelled


Accounts Receivable Record List
Adding Accounts Receivable
  1. Go to Financials then click Accounts Receivable
  2. Click Add Accounts Receivable
  3. Fill up the necessary fields in the Header Part
  4. Fill up the necessary fields in the Accounting Details then Click Save
Adding Accounts Receivable Information
Field Description Expected Values
1. Voucher No. •Voucher Reference number generated upon creation •Alphanumeric(Auto-Generated)
2.Customers •Name of Customer •Customer List provided in the Customer  Maintenance Module
3.Tax Identification Number(TIN) •TIN of the Customer •Number(Auto-Generated base from Customer's Profile)
4.Terms Days on completing the sale •Number(Auto-Generated base from the

Customer's Profile)

5.Address •Address of the Customer •Alphanumeric(Auto-Generated base from the Customer's Profile)
6.Proforma •Financial statements is to facilitate comparisons of historic data and projections of future performance. •Proforma list provided in the Proforma Maintenance Module
7.Transaction Date •Date when the Payable Transaction was created •Date
8.Due Date •Due date of Payable Transaction •Date
9.Invoice No •Invoice number reference for the transaction •Alphanumeric
10.Reference No •Reference No for the transaction •Number
11.Notes •Other Remarks on the Transaction •Alphanumeric
12.Account •Account to be charged for credit and debit amount on the transaction •Account list in the Chart of Accounts Maintenance Module
13.Description •Any remarks or Notes in the Account Line of the transaction •Alphanumeric
14.Debit •Debit Amount for the Transaction •Number
15.Credit •Credit Amount for the Transaction •Number
16.Value Added Tax(VAT) •VAT to be applied in the amount on the accounting details in the transaction •Tick/Untick
17.Tax •Type of Tax to be applied when the VAT is ticked •Tax List provided in the Tax Maintenance Module

Notes:

  • Account 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.
    • This can be seen in Proforma Maintenance Module
  • Customer should be on ACTIVE status when using it upon creating or editing a transaction.
    • This can be seen in Customers Maintenance Module
  • Tax should be on ACTIVE status when using it upon creating or editing a transaction.
    • This can be seen in Tax Maintenance Module
    • This will be only available in the transaction when the VAT column is checked.
Importing and Exporting Accounts Receivable
  1. Under Accounts Receivable Screen, Click Options
  2. Under Options, the user may Export or Import Accounts Receivable
    • When Exporting the records, the user may also use the filter options such as Date Filter, Search Bar and Customer filter for precise searching and exporting of records.
    • For batch creation, under Accounts Receivable menu, click options then choose Import Accounts Receivable button
      • Download the Template provided in the Step 1
      • Fill up the information needed for each column of the template
      • Upload the updated template then click Import to Proceed


Accounts Receivable Import Fields
Field Description of Data Output Allowed Inputs Input Restrictions Required (Y/N)
1. Document Set Manual entry of Document Set of Accounts Receivable (e.g., 1, 2, 3, A, B, C) *Alphanumeric

*Underscore (_)

*Other special characters not mentioned Y
2. Transaction Date Manual entry of Transaction Date of Accounts Receivable *Numeric

*Dash (-), Backslash (/)

*Other special characters not mentioned Y
3. Due Date Manual entry of Due Date of Accounts Receivable – must be based on Customer’s payment terms *Numeric

*Dash (-), Backslash (/)

*Other special characters not mentioned Y
4. Customer Code Manual entry of Customer code – must be based from Customer Data maintenance *Numeric

* Customer Code based from Customer maintenance

*Any input not mentioned  in the required inputs Y
5. Invoice No. Manual entry of Accounts Receivable Invoice No. *Alphanumeric

*Underscore (_), Dash (-)

*Other special characters not mentioned N
6. Reference No. Manual entry of Accounts Receivable Reference No. *Alphanumeric

*Underscore (_), Dash (-)

*Other special characters not mentioned N
7. Notes Manual entry of Accounts Receivable Notes *Alphanumeric

*Underscore (_), Dash (-)

*Other special characters not mentioned N
8. Account Code Manual entry of Account Code – must be based from Chart of Accounts maintenance *Numeric

*Account Code based from Chart of Accounts maintenance

*Any input not mentioned  in the required inputs Y
9. Description Manual entry of Account Description *Alphanumeric

*Special Characters

*None N
10. Debit Manual entry of Debit amount *Numeric *Any input excepts numbers Y
11. Credit Manual entry of Credit amount *Numeric *Any input excepts numbers Y
Accounts Receivable Record Option
Actions Available base on Accounts Receivable Record Status
Status View Edit Post Receive Payment Cancel
UNPAID
POSTED
WITH PARTIAL PAYMENT
PAID
CANCELLED


Notes:

  • The user can only Receive Payment the Accounts Receivable if the Receivable transaction has tag reference on it.
    • Posted Receivable can also received payments but cannot be edited.


Categories:
Modules
Financials Financials | Accounts Receivable | Receipt Voucher
Sales Delivery Receipt | Sales Invoice
Maintenance Customer | Proforma | Chart of Account | Tax
Job Aid Modules
Maintenance Aids Customer Aids | Proforma Aids | Chart of Accounts Aids | Tax Aids