How to Upload Outstanding Bills into the Migration Template?

January 1, 2025

Utilize the Open Bills Template to systematically track outstanding bills that your company needs to settle. Include pertinent information such as the bill number, date, due date, vendor name, total amount, and the unpaid amount. This template ensures an organized approach to managing and settling outstanding financial obligations.

 

Follow the step-by-step instructions to complete the Migration Account Payable Template from your AP summary.

Here is the sample AP Summary (as extracted from Books)

S.no

Date

Supplier Name*

Bill No *

Amount *

Tax

Total

Terms

1

12-01-2022

Robert & Co

 PDec22-2

$ 825

-

$ 825

Net 15

2

12-11-2022

Antony & Associates

 PDec22-11

$ 1250

-

$ 1250

Net 15

3

12-12-2022

Excellent Trading & Co

 PDec22-12

$ 950

-

$ 950

Net 15

Transaction Details:

1)  Bill outstanding with Vendor Robert & Co for USD 825 - Accounts Payable – Supplies

2)  Bill outstanding with Vendor Antony & Associates for USD 1250 - Accounts Payable – Consumables

3)  Bill outstanding with Vendor Excellent Trading & Co for USD 950 - Accounts Payable – Supplies

Here is the Sample Migration Accounts Payable  Register updated based on the above AP Summary

Fields

Description

Bill Date

The date entered by the user when this transaction occurred.

Bill No

Reference number for the transaction

Supplier Name

Vendor Name

Amount

The amount of the Line Item

Tax

Tax is associated with the Bill

Category 

Expense Account

Terms

Aging of the vendor

Related to the previous Year

If the bill transaction is related to the previous year

Let's delve into the details of the Migration Accounts Payable Template Fields and their corresponding information:

Bill Date: This field captures the specific date on which the bill transaction took place. It reflects when the user recorded the occurrence of the financial transaction.

Bill No: The bill number serves as a unique identifier for the transaction, enabling easy reference and tracking. It is a crucial element for organizing and categorizing bills.

Supplier Name: This field indicates the name of the supplier or vendor associated with the bill transaction. It provides clarity on the entity to whom the payment is due.

Amount: The amount field records the monetary value of the bill, indicating the total amount associated with the specific line item in the transaction.

Tax: If there is any tax applicable to the bill, this field captures the associated tax amount. It contributes to the accurate representation of the total financial obligation.

Terms: Terms refer to the agreed-upon payment conditions or aging of the vendor's account. It indicates the time frame within which the payment is expected to be made.

Related to the previous Year: This field helps determine whether the bill transaction is associated with the previous year. It aids in maintaining a historical record of financial activities.

Example Transaction 1:

Bill outstanding with Vendor Robert & Co for USD 825 - Accounts Payable – Supplies

S.No

Date

Supplier Name*

Bill No *

Amount *

Tax

Total

Terms

1

12-01-2022

Robert & Co

 PDec22-2

$ 825

-

$ 825

Net 15

Here is the Sample Account Payable Bank Register updated based on the above AP Summary

Example Transaction 2:

Bill outstanding with Vendor Antony & Associates for USD 1250 - Accounts Payable – Consumables

S.No

Date

Supplier Name*

Bill No *

Amount *

Tax

Total

Terms

2

12-11-2022

Antony & Associates

 PDec22-11

$ 1250

-

$ 1250

Net 15

Here is the Sample Account Payable Bank Register updated based on the above AP Summary

Example Transaction 3:

Bill outstanding with Vendor Excellent Trading & Co for USD 950 - Accounts Payable – Supplies

S.No

Date

Supplier Name*

Bill No *

Amount *

Tax

Total

Terms

3

12-12-2022

Excellent Trading & Co

 PDec22-12

$ 950

-

$ 950

Net 15

Here is the Sample Account Payable Bank Register updated based on the above AP Summary

If you encounter any challenges, feel free to reach out to us at migration-support@saasant.com.

Automated data Import / Export to QuickBooks Online
Say goodbye to the hassle of managing transactions manually
Grow exponential with Clear Financial Visibility