Upload your purchase transactions so Kintsugi can calculate what you owe or can recover on the buy side. In the US this means consumer use tax, where the vendor did not charge the full tax due. In the EU and UK it means input VAT, the VAT you paid your own suppliers.
Time required: about 10 minutes for a prepared file
You will need: a Premium plan, a purchase CSV that follows the standard transaction template, and either use tax enabled for your organization (for US purchases) or the EU VAT Accounts Payable setting enabled (for input VAT). One of these also controls whether the Sales and Purchases tabs appear on your Transactions page.
Uploading sales instead? Sales and purchase uploads look alike, since both start from Data Sources and the File Upload section. The difference is your role in the transaction: upload sales when you sold to your customers, and upload purchases when you bought from your vendors. For sales, see How to Upload Sales Transactions in Kintsugi. The two uploads use different templates and settings, so follow the guide that matches your data.
Each row's ship-to address must be the place where the purchase is used, not the billing address. If a purchase, such as software or a service, is used across several locations, split it into separate rows and allocate the amount across those locations before you upload. Kintsugi does not split purchases for you.
Addresses for US purchases: the state and postal code are used to rate each row, and the country must be filled in. A street address is not required for the file to upload.
The purchase template uses buy-side column names, so some columns differ from the sales template. Vendor replaces customer, place-of-use replaces ship-to, and there is a ship-from field for where the goods or services came from. The template also has an optional tax ID column for your vendor.
Include the tax you have already paid on each row. For EU and UK purchases this is the VAT your supplier charged you. Kintsugi needs it to work out how much you can recover.
Tell Kintsugi where each EU and UK purchase came from. Whether a purchase is cross-border decides how it is taxed, so Kintsugi needs an origin country. It looks for one in this order:
The ship-from field on the row
The supplier country on the upload
The address stored for that vendor
The country of the vendor's VAT registration, where available
If none of these gives an origin, the purchase is treated as domestic rather than cross-border. Filling in ship-from on every row is the most reliable way to get this right.
Go to Data Sources.
Click on the File Upload section.
Select the platform your transaction data comes from.
For purchases, choose Other (or a CSV-based source) instead of a connected platform such as Shopify. Purchases are uploaded by CSV only and are not synced from integrations, so a platform source can mix them in with your synced sales.
Sales remain the default. So, you need to change it and set the transaction type to Purchases. Purchases are transactions where you are the buyer, and selecting this means you are uploading these purchases, which may be subject to Use Tax or Input VAT.
Download the template for your selected source. Use the template, fill it with your transaction data. Follow the template to avoid upload errors.
Use the Purchases template, not the sales template. In the purchase template, set transaction_type to SALE and direction to PURCHASE on each row. PURCHASE is a direction, not a transaction type, so do not enter it in the transaction_type column.
a. Upload the CSV by either clicking Choose File or by dragging and dropping the file to the dropbox.
TIP: Confirm each row's ship-to address is the usage location and that any multi-location purchase is already split and allocated.
Test a small batch first. Upload a few rows, check them on the Purchases tab under Transactions, and then upload the rest of the file.
Open your upload history and check that the file is marked as a purchase upload.
Go to Transactions.
Choose the Purchases section.
View the details of your purchases.
Your purchases appear there, with total purchase transanctions, total purchase amount, total use tax owed, and total tax already paid, and line list of details. Your sales figures do not change.
For EU and UK purchases, open an individual purchase to see the VAT paid or self-assessed on it and how much of that you can recover, shown in the currency of the country. A purchase where you paid 210 EUR of VAT might show 168 EUR as recoverable, with the difference explained by the two factors described below.
If you’ve uploaded a large number of purchase transactions, use the search bar or filters to quickly narrow down results and locate the transaction you need.
You can also export your purchase transactions by clicking on the export button.
Adjust the columns to display the detail, set them up the way you like.
For US purchases, Kintsugi calculates the use tax due on each purchase row and shows it on the Purchases tab under Transactions, including the total use tax owed.
Use tax is added to your filing for a state only when you are registered for use tax in that state. In states with a single combined sales and use tax return, such as California, registering for use tax does not create a new registration. Kintsugi uses your existing sales tax registration, shows a message confirming that your purchases with use tax will be added to your filings, and your open returns for that state then include both sales and use tax.
If the filing for the period was already generated before your purchases were uploaded or before use tax was registered, it needs to be recalculated before the use tax appears on it. Contact us if you need a filing recalculated.
If your purchase rows are in a country where you hold an EU or UK VAT registration, Kintsugi works out how much of the VAT on them you can recover and applies it for you.
Kintsugi treats a purchase as either domestic or cross-border, based on its origin country, and the VAT it starts from is different for each.
Domestic purchases use the VAT on your vendor's invoice, which is the VAT paid amount on your row
Cross-border purchases are treated as reverse charge, and use the VAT Kintsugi calculates rather than the invoice amount. This applies even if your vendor charged you VAT
Two things decide how much of that VAT you can claim back:
Recoverability. In some countries, certain products do not allow you to recover all of the VAT you paid. Kintsugi holds a recoverability percentage for each combination of product category and country, anywhere from 0% to 100%. Where no percentage has been set, the purchase is treated as fully recoverable. These percentages are maintained by Kintsugi, and you cannot change them yourself. If one looks wrong for your business, contact us
The pro rata coefficient. If you make both exempt and non-exempt sales, the VAT you can claim back is reduced by the ratio of non-exempt sales to total sales. Kintsugi sets a provisional ratio for the year from your prior-year sales, or 100% if there are none, applies it across the year's filing periods, and corrects it once your actual full-year sales are known. Businesses with no exempt sales are unaffected
Recoverability and the pro rata coefficient never change the VAT amount recorded on the purchase itself. They only change how much of it you can reclaim.
Once your purchases are uploaded, go to Filings and open the filing for the period to review the result. The Tax Overview in Filing Details shows two rows from your purchases:
Self-assessed VAT, the VAT you account for yourself on reverse-charge purchases, which is added to what you owe
Input VAT recovered, the VAT you can claim back, which is subtracted from what you owe. All of it is combined into this one line rather than broken out per purchase
Credits Utilized shows any credits applied to the filing, and Total Liability is what remains due. For example, 2,000.00 GBP of Output VAT, plus 200.00 GBP of Self-assessed VAT, less 400.00 GBP of Input VAT recovered, gives a Total Liability of 1,800.00 GBP.
Kintsugi works through each period in this order:
The period's recoverable input VAT is netted against the VAT you owe
Any Input VAT Credits you already hold are applied to what is still due
If recoverable input VAT is greater than the VAT you owe, the filing stops at zero and the surplus becomes a new Input VAT Credit for a future period
A filing never drops below zero. See How to Add Input Credits for Canada and the EU.
If you import goods under postponed VAT accounting, you do not pay VAT at the border, so leave the VAT paid amount on those rows as 0. Kintsugi accounts for the import VAT itself and claims back the recoverable portion on the same period's return, so a fully recoverable import nets out to nothing.
Import VAT you actually paid at the border, and customs duty, stay outside Kintsugi's calculation. Postponed VAT accounting is the exception, because the VAT goes onto your return rather than being settled at the border.
Purchases enter Kintsugi through CSV upload only. Syncing purchases from an accounting or commerce integration is not supported.
Purchase data is stored and processed separately from sales and never counts toward sales totals
Kintsugi does not automatically allocate a purchase used across several locations. Split and allocate before upload
For cross-border purchases, Kintsugi calculates the VAT itself rather than using the amount on your vendor's invoice, so the two can differ. Domestic purchases use the invoice amount
The origin country decides whether a purchase is domestic or cross-border, so fill in ship-from on every EU and UK row
Do not enter the same reclaim twice. If Kintsugi is calculating input VAT from your uploaded purchases, do not also add that amount as a manual Input VAT Credit
You do not see a Purchases tab or the option to upload purchases. Purchases are available only when your organization is on a Premium plan and has use tax or the EU VAT Accounts Payable setting enabled. Until then, the upload screen shows only Source and Download template, and the template you download is the sales template. These settings are turned on by Kintsugi, so contact us to request them. Once they are on, the Sales and Purchases selector and the purchase template appear on the upload screen.
Rows fail validation on transaction_type, or purchases are processed as sales. PURCHASE was entered in the transaction_type column, or the file was built from the sales template. Download the Purchases template, set transaction_type to SALE and direction to PURCHASE, and upload the file again.
A cross-border purchase was not treated as reverse charge. Kintsugi could not find an origin country for it, so it was treated as domestic. Add the ship-from country to the row and upload it again.
The VAT you can recover is lower than the VAT on the invoice. This is expected when the product category is not fully recoverable in that country, or when your exempt sales reduce your pro rata coefficient.
The filing shows zero, but you expected a refund. Kintsugi never files a negative amount. The surplus is stored as an Input VAT Credit and applied to a future period.
Use tax shows on the Transactions tab but not on your filing. Use tax only flows into a filing when you are registered for use tax in the state where the purchase was used. If the use tax exposure for that state was disregarded, contact us to restore it, then click Register on it. In states with a combined sales and use tax return, such as California, this does not create a new registration. If the filing was already generated, it also needs to be recalculated before the use tax appears.
If you are still stuck, contact us with the purchase or upload involved and the filing period.
Q: Can I sync purchases from QuickBooks, Shopify, or another integration?
A: No. Purchases are supported through CSV upload only. Connected integrations continue to sync sales transactions.
Q: What if my file mixes sales and purchases?
A: Rows that carry their own transaction type are processed as labeled. Rows without one follow the transaction type you selected during upload. If you are unsure, upload sales and purchases as separate files.
Q: I do not see a Purchases tab on my Transactions page.
A: The Sales and Purchases tabs appear only if your organization has use tax enabled or the EU VAT Accounts Payable setting enabled. Contact us if you expect to see them and do not.
Q: Do I need to upload purchases if I only sell in the EU or UK?
A: Only if you want your input VAT reflected. Your sales and the VAT you owe are calculated without them. Uploading purchases is what lets Kintsugi reduce that figure by the VAT you already paid your suppliers.
Q: Why does the input VAT Kintsugi calculated not match my supplier's invoice?
A: For a cross-border purchase, Kintsugi calculates the VAT itself rather than reading it off the invoice, so the two can differ. For any purchase, recoverability and your pro rata coefficient can also reduce how much you can claim back.
Q: Does a reverse-charged purchase always net to zero?
A: No. If the product category is not fully recoverable in that country, you still owe the share that cannot be recovered.
Q: Can I change a recoverability percentage myself?
A: No. Recoverability percentages are maintained by Kintsugi. Contact us if a category looks wrong for your business.
Q: I already entered a manual Input VAT Credit. What happens now?
A: Your existing credits still apply, after the period's own recoverable input VAT has been netted. Any unused reclaim still becomes a new credit. Just make sure you do not enter the same reclaim manually that Kintsugi is already calculating from your purchases.
Q: What do I enter for goods imported under postponed VAT accounting?
A: Leave the VAT paid amount as 0, since you did not pay VAT at the border. Kintsugi accounts for the import VAT and recovers the recoverable portion on the same return.
For further concerns, we're always here to help. If you can't find the answer you're looking for, just reach out to us using the chat in the bottom right corner of your screen.