Difference between revisions of "Accounts Receivable"

Line 10: Line 10:
 
=====Adding Accounts Receivable=====
 
=====Adding Accounts Receivable=====
 
[[File:Adding Accounts Receivable.png|center|thumb|863x863px|Adding Accounts Receivable]]
 
[[File:Adding Accounts Receivable.png|center|thumb|863x863px|Adding Accounts Receivable]]
<br />
 
  
 
*'''Adding Accounts Receivable Information'''
 
*'''Adding Accounts Receivable Information'''
Line 19: Line 18:
 
!Expected Values
 
!Expected Values
 
|-
 
|-
|1.[[Customers]]
+
|1. Voucher No.
 +
|<span style="color: rgb(34, 34, 34)">•Voucher Reference number generated upon creation</span>
 +
|<span style="color: rgb(34, 34, 34)">•Alphanumeric(Auto-Generated)</span>
 +
|-
 +
|2.[[Customers]]
 
|•Name of Customer
 
|•Name of Customer
 
|•Customer List provided in the Customer  Maintenance Module
 
|•Customer List provided in the Customer  Maintenance Module
 
|-
 
|-
|2.[[Proforma]]
+
|3.Tax Identification Number(TIN)
 +
|<span style="color: rgb(34, 34, 34)">•TIN of the Supplier</span>
 +
|<span style="color: rgb(34, 34, 34)">•Number(Auto-Generated base from Customer's Profile)</span>
 +
|-
 +
|4.Terms
 +
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•</span>Days on completing the sale
 +
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Number(Auto-Generated base from the</span>
 +
<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">Customer's</span> <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">P</span><span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">rofile)</span>
 +
|-
 +
|5.Address
 +
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Address of the Customer</span>
 +
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Alphanumeric(Auto-Generated base from the Customer's Profile)</span>
 +
|-
 +
|6.[[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
 
|-
 
|-
|3.Transaction Date
+
|7.Transaction Date
 
|•Date when the Payable Transaction was created
 
|•Date when the Payable Transaction was created
 
|•Date
 
|•Date
 
|-
 
|-
|4.Due Date
+
|8.Due Date
 
|•Due date of Payable Transaction
 
|•Due date of Payable Transaction
 
|•Date
 
|•Date
 
|-
 
|-
|5.Invoice No
+
|9.Invoice No
 
|•Invoice number reference for the transaction
 
|•Invoice number reference for the transaction
 
|•Alphanumeric
 
|•Alphanumeric
 
|-
 
|-
|6.Reference No
+
|10.Reference No
 
|•Reference No for the transaction
 
|•Reference No for the transaction
 
|•Number
 
|•Number
 
|-
 
|-
|7.Notes
+
|11.Notes
 
|•Other Remarks on the Transaction
 
|•Other Remarks on the Transaction
 
|•Alphanumeric
 
|•Alphanumeric
 
|-
 
|-
|8.[[Chart of Account|Account]]
+
|12.[[Project]]
 +
|•Assigned Project on a specific Accounting Line
 +
|•Project List in the Project Maintenance Module
 +
|-
 +
|13.[[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
 
|-
 
|-
|9.Debit
+
|14.Description
 +
|•Any remarks or Notes in the Account Line of the transaction
 +
|•Alphanumeric
 +
|-
 +
|15.Debit
 
|•Debit Amount for the Transaction
 
|•Debit Amount for the Transaction
 
|•Number
 
|•Number
 
|-
 
|-
|10.Credit
+
|16.Credit
 
|•Credit Amount for the Transaction
 
|•Credit Amount for the Transaction
 
|•Number
 
|•Number
 +
|-
 +
|17.Value Added Tax(VAT)
 +
|•VAT to be applied in the amount on the accounting details in the transaction
 +
|•Tick/Untick
 +
|-
 +
|18.[[Tax]]
 +
|•Type of Tax to be applied when the VAT is ticked
 +
|•Tax List provided in the Tax Maintenance Module
 
|}
 
|}
  
Line 70: Line 102:
 
*Customer should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
*Customer should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
**This can be seen in [[Customers]] Maintenance Module
 
**This can be seen in [[Customers]] Maintenance Module
 +
* Project should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
 +
** This can be seen in [[Project]] 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.
  
 
*For detailed steps on how to Add an Accounts Receivable, you can visit the Accounts Receivable Job Aids which can be found  [[Accounts Receivable Aids|here]]
 
*For detailed steps on how to Add an Accounts Receivable, you can visit the Accounts Receivable Job Aids which can be found  [[Accounts Receivable Aids|here]]
Line 84: Line 121:
 
!Expected Values
 
!Expected Values
 
|-
 
|-
|1.[[Customers]]
+
|1. Voucher No.
 +
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Voucher Reference number generated upon creation</span>
 +
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Alphanumeric(Auto-Generated)</span>
 +
|-
 +
|2.[[Customer|Customers]]
 
|•Name of Customer
 
|•Name of Customer
 
|•Customer List provided in the Customer  Maintenance Module
 
|•Customer List provided in the Customer  Maintenance Module
 
|-
 
|-
|2.[[Proforma]]
+
|3.Tax Identification Number(TIN)
 +
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•TIN of the Supplier</span>
 +
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Number(Auto-Generated base from Customer's Profile)</span>
 +
|-
 +
|4.Terms
 +
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•</span>Days on completing the sale
 +
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Number(Auto-Generated base from the</span>
 +
<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">Customer's</span> <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">Profile)</span>
 +
|-
 +
|5.Address
 +
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Address of the Customer</span>
 +
|<span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}">•Alphanumeric(Auto-Generated base from the Customer's Profile)</span>
 +
|-
 +
|6.[[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
 
|-
 
|-
|3.Transaction Date
+
|7.Transaction Date
 
|•Date when the Payable Transaction was created
 
|•Date when the Payable Transaction was created
 
|•Date
 
|•Date
 
|-
 
|-
|4.Due Date
+
|8.Due Date
 
|•Due date of Payable Transaction
 
|•Due date of Payable Transaction
 
|•Date
 
|•Date
 
|-
 
|-
|5.Invoice No
+
|9.Invoice No
 
|•Invoice number reference for the transaction
 
|•Invoice number reference for the transaction
 
|•Alphanumeric
 
|•Alphanumeric
 
|-
 
|-
|6.Reference No
+
|10.Reference No
 
|•Reference No for the transaction
 
|•Reference No for the transaction
 
|•Number
 
|•Number
 
|-
 
|-
|7.Notes
+
|11.Notes
 
|•Other Remarks on the Transaction
 
|•Other Remarks on the Transaction
 
|•Alphanumeric
 
|•Alphanumeric
 
|-
 
|-
|8.[[Chart of Account|Account]]
+
|12.[[Project]]
 +
|•Assigned Project on a specific Accounting Line
 +
|•Project List in the Project Maintenance Module
 +
|-
 +
|13.[[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
 
|-
 
|-
|9.Debit
+
|14.Description
 +
|•Any remarks or Notes in the Account Line of the transaction
 +
|•Alphanumeric
 +
|-
 +
|15.Debit
 
|•Debit Amount for the Transaction
 
|•Debit Amount for the Transaction
 
|•Number
 
|•Number
 
|-
 
|-
|10.Credit
+
|16.Credit
 
|•Credit Amount for the Transaction
 
|•Credit Amount for the Transaction
 
|•Number
 
|•Number
|}
+
|-
 
+
|17.Value Added Tax(VAT)
Notes:
+
|•VAT to be applied in the amount on the accounting details in the transaction
 +
|•Tick/Untick
 +
|-
 +
|18.[[Tax]]
 +
|•Type of Tax to be applied when the VAT is ticked
 +
|•Tax List provided in the Tax Maintenance Module
 +
|}Notes:
  
 
*Auto generated Accounts Receivable can only be edited through its reference [[Delivery Receipt]].
 
*Auto generated Accounts Receivable can only be edited through its reference [[Delivery Receipt]].
Line 138: Line 206:
 
**This can be seen in [[Customers]] Maintenance Module
 
**This can be seen in [[Customers]] Maintenance Module
 
**Past Transactions with '''INACTIVE''' status prior to its deactivation can still be used.
 
**Past Transactions with '''INACTIVE''' status prior to its deactivation can still be used.
 +
* Project should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
 +
** This can be seen in [[Project]] 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.
  
 
*For detailed steps on how to Edit an Accounts Receivable, you can visit the Accounts Receivable Job Aids which can be found [[Accounts Receivable Aids|here]]
 
*For detailed steps on how to Edit an Accounts Receivable, you can visit the Accounts Receivable Job Aids which can be found [[Accounts Receivable Aids|here]]
Line 160: Line 233:
  
 
=====Accounts Receivable View Record=====
 
=====Accounts Receivable View Record=====
[[File:Accounts Receivable View Record.png|center|thumb|Accounts Receivable View Record]]
+
[[File:Accounts Receivable View Record.png|center|thumb|699x699px|Accounts Receivable View Record]]
  
 
*For detailed steps on how to View an Accounts Receivable, you can visit the Accounts Receivable Job Aids which can be found [[Accounts Receivable Aids|here]]
 
*For detailed steps on how to View an Accounts Receivable, you can visit the Accounts Receivable Job Aids which can be found [[Accounts Receivable Aids|here]]
Line 175: Line 248:
 
|-
 
|-
 
|Maintenance
 
|Maintenance
|[[Customer]]<nowiki> | </nowiki>[[Proforma]]<nowiki> | </nowiki>[[Chart of Account]]<nowiki> | </nowiki>[[Tax]]
+
|[[Customer]]<nowiki> | </nowiki>[[Proforma]]<nowiki> | </nowiki>[[Project]]<nowiki> | </nowiki>[[Chart of Account]]<nowiki> | </nowiki>[[Tax]]
 
|-
 
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
Line 186: Line 259:
 
|-
 
|-
 
|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>[[Project Aids]]<nowiki> | </nowiki>[[Chart of Accounts Aids]]<nowiki> | </nowiki>[[Tax Aids]]
 
|}
 
|}

Revision as of 11:07, 7 April 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.

Accounts Receivable Record List
File:Accounts Receivable Record List.png
Accounts Receivable Record List
Adding Accounts Receivable
File:Adding Accounts Receivable.png
Adding Accounts Receivable
  • 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 Supplier •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.Project •Assigned Project on a specific Accounting Line •Project List in the Project Maintenance Module
13.Account •Account to be charged for credit and debit amount on the transaction •Account list in the Chart of Accounts Maintenance Module
14.Description •Any remarks or Notes in the Account Line of the transaction •Alphanumeric
15.Debit •Debit Amount for the Transaction •Number
16.Credit •Credit Amount for the Transaction •Number
17.Value Added Tax(VAT) •VAT to be applied in the amount on the accounting details in the transaction •Tick/Untick
18.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
  • Project should be on ACTIVE status when using it upon creating or editing a transaction.
    • This can be seen in Project 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.
  • For detailed steps on how to Add an Accounts Receivable, you can visit the Accounts Receivable Job Aids which can be found here
Editing Accounts Receivable
File:Editing Accounts Receivable.png
Editing Accounts Receivable


  • Editing 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 Supplier •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.Project •Assigned Project on a specific Accounting Line •Project List in the Project Maintenance Module
13.Account •Account to be charged for credit and debit amount on the transaction •Account list in the Chart of Accounts Maintenance Module
14.Description •Any remarks or Notes in the Account Line of the transaction •Alphanumeric
15.Debit •Debit Amount for the Transaction •Number
16.Credit •Credit Amount for the Transaction •Number
17.Value Added Tax(VAT) •VAT to be applied in the amount on the accounting details in the transaction •Tick/Untick
18.Tax •Type of Tax to be applied when the VAT is ticked •Tax List provided in the Tax Maintenance Module

Notes:

  • Auto generated Accounts Receivable can only be edited through its reference Delivery Receipt.
  • Account should be on ACTIVE status when using it upon creating or editing a transaction.
    • This can be seen in Chart of Account Maintenance Module.
    • Past Transactions with INACTIVE status prior to its deactivation can still be used.
  • 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 status prior to its deactivation can still be used.
  • Customer should be on ACTIVE status when using it upon creating or editing a transaction.
    • This can be seen in Customers Maintenance Module
    • Past Transactions with INACTIVE status prior to its deactivation can still be used.
  • Project should be on ACTIVE status when using it upon creating or editing a transaction.
    • This can be seen in Project 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.
  • For detailed steps on how to Edit an Accounts Receivable, you can visit the Accounts Receivable Job Aids which can be found here
Accounts Receivable Options
File:Accounts Receivable Options.png
Accounts Receivable Options
  • For detailed steps on how to Import and Export an Accounts Receivable, you can visit the Accounts Receivable Job Aids which can be found here
Accounts Receivable Importation Option
File:Accounts Receivable Importation Option.png
Accounts Receivable Importation Option
  • For detailed steps on how to Import an Accounts Receivable, you can visit the Accounts Receivable Job Aids which can be found here
Accounts Receivable Record Option
File:Accounts Receivable Record Option.png
Accounts Receivable Record Option

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.
  • For detailed steps on how to View, Edit, Print, Post and Cancel an Accounts Receivable, you can visit the Accounts Receivable Job Aids which can be found here
Accounts Receivable View Record
File:Accounts Receivable View Record.png
Accounts Receivable View Record
  • For detailed steps on how to View an Accounts Receivable, you can visit the Accounts Receivable Job Aids which can be found here
Categories:
Modules
Financials Accounts Receivable | Credit Voucher | Receipt Voucher | Financials
Sales Delivery Receipt | Sales Invoice
Maintenance Customer | Proforma | Project | Chart of Account | Tax
Job Aid Modules
Financials Aids Accounts Receivable Aids | Credit Voucher Aids | Receipt Voucher Aids
Sales Aids Delivery Receipt Aids | Sales Invoice Aids
Maintenance Aids Customer Aids | Proforma Aids | Project Aids | Chart of Accounts Aids | Tax Aids