Adding Purchase Transactions

Learn how to add and bulk import purchase transactions in JuanTax.

Maui Banag avatar
Written by Maui Banag
Updated over a week ago

Adding purchase transactions manually

STEP 1: To start adding transactions in JuanTax, click on the sidebar menu and select Transactions.

STEP 2: On the next screen, click on the Purchases tab. On the upper right part, click the + Add Transaction button then select Add Manual.

STEP 3: When adding a new Purchase manually, you can either Search Vendor adding all previous transactions or Add Vendor with completely new transactions.

Date and Reference are required fields.

STEP 4: Enter details of your transaction into the Description field to understand the transaction better. Once added, choose the correct Tax Type.

  • The Tax Type column would affect the population of your VAT return and is only available if the organization is a VAT registered entity.

  • ATC chosen will determine which type of report the transaction(s) will be automatically pushed into (eg: Expanded Withholding Tax, Final Withholding Tax) The ATC column will only be populated if there are any taxes withheld from your VENDOR. Choose among the list of withholding codes, or type the nature of the transaction to filter the correct withholding code quickly.

  • The next column is the COA Column. JuanTax created a set of COA that is patterned to ITR sections which are selected here. You can add more Chart Of Accounts in the organization setting. Lastly, enter the receipt’s gross amount.

Other buttons you can check:

  • Notes and Activities - On the upper right part of your transaction, you can see the history of the changes made to each transaction and any notes left for checking purposes.

  • Upload Image - You can upload the image of the document representing your transaction to store them as a reference. Per BIR Revenue Regulations RR 5-2014, you are required to preserve hard copies of your books of accounts and other documents for the first five years, and thereafter, retain electronic copies. Added files will only be visible to users with access to your company.

  • Save - Save: You can choose to Save & Close to save the transaction and close the current screen or hit Save and Next to save the current transaction and start adding a new one.


Importing Purchase Transactions using CSV

All you need to do is paste your accounting data in a CSV template provided in the transaction module and import the CSV using the import wizard to get all your accounting entries in JuanTax faster.

STEP 1: Start importing your CSV file by clicking the + Add Transaction button then select Import CSV.

STEP 2: Once you're done completing the CSV file, you may proceed with importing your transactions by clicking the Browse button.

There are two files available:

a. CSV file - Fill this out with your transaction information. Mandatory fields are marked with an asterisk in the import file such as DATE, INVOICE NO., CATEGORY, TAX TYPE, ATC, and GROSS AMOUNT.

b. Chart of Accounts - this sheet contains all the possible reference codes that are needed within the COA Code field of your CSV template.

STEP 3: Locate your CSV file and click Open.

STEP 4: Click the Next button.

STEP 5: Map the fields of your CSV file with the appropriate transaction fields.

STEP 6: Make sure to review the mapped transactions before continuing, and once finished, click Done.

That's it! Your purchase transactions are now successfully imported into JuanTax.

These uploaded transactions will now appear on your Transactions module under the Purchases tab.

Helpful links:

Did this answer your question?