Summary
QuickBooks Online offers a payment import utility where you can import payments made through Aiwyn.
Please first read their help article on building and using this tool in QBO.
Included in this article:
Template
The following template is similar to what will be provided by Aiwyn daily to QBO using firms who would like to import payments made through Aiwyn:
| Date | Description | Credit |
| 1/31/2023 | AIW-Invoice-12345-Client-1001-PI-0111-0011 | 100.00 |
| 1/31/2023 | AIW-Invoice-20034-Client-2002-PI-0112-0022 | 200.00 |
| 1/31/2023 | AIW-Invoice-20114-Client-2002-PI-0112-0023 |
150.00 |
Description of fields
- AIW: The Aiwyn Payment Identifier, required to include when you reconcile an invoice payment that was paid through Aiwyn
- Invoice-#####: The invoice number that was paid through Aiwyn (not required but recommended to help you with matching)
- Client-####: The client number associated with the invoice that was paid through Aiwyn (not required but recommended to help you with matching)
-
PI-####-####: The unique Payment ID (PI). In order for your reports to run and display information accurately, each row in the file must have a unique Payment ID. Remember, with Aiwyn a client can pay multiple invoices at once, or the same invoice split between two different payment methods, therefore this unique number will help to tie everything together.
- For example, let's consider Client-2002 (last two rows). They made a single payment but paid two invoices at once. Notice how the first set of PI's are the same number (0112) while the second set of numbers are unique. Altogether, this creates a unique string of data generated, but also helps to let you know they made a single payment action but actually paid two different items.