Apron

If your company is connected to QuickBooks, you will first need to decide how you want to upload unreconciled transactions to Apron. There are two methods available:

1. Direct Sync to QuickBooks
2. Manual Upload

Choose the method that best suits your workflow preferences and follow the detailed steps provided in the subsequent sections of this article.

Option 1: Direct sync to Quickbooks

Setup: Choose the category (account) from which Apron should sync expense transactions. While 'Uncategorised Expense' is commonly used, you may select any category you prefer. ​

Allocate bank transactions in Quickbooks:

1. Open your QuickBooks Online account.
2. Navigate to Bank Transactions.
3. Select any bank transactions lacking invoices/receipts.
4. Allocate these to the chosen category. QuickBooks will then create matching expense transactions that move to the 'Categorised' section of your Bank Feed. ​

1. Once transactions are allocated to a correct category in QuickBooks, they will appear in the 'Unreconciled Transactions' tab in Apron .
2. Assign these transactions to clients to provide the required documents (refer to <a href="https://support.getapron.com/en/articles/9323827-how-does-apron-work-with-unreconciled-transactions">this article</a> for more details).
3. After clients attach documents, you can review these in Apron and then publish them to your accounting software. You will see that the document is linked to a corresponding transaction.
4. Publishing documents linked to transactions updates the corresponding expense transaction in QuickBooks with new details such as category, VAT rate, description, and reference, eliminating the need for additional reconciliation in QuickBooks.
5. Once published, the transaction moves to a 'Resolved' state and is removed from the list. To access resolved transactions later, use the filter to view them.

1. Setup: Choose the category (account) from which Apron should sync expense transactions. While 'Uncategorised Expense' is commonly used, you may select any category you prefer. ​
 
 
2. Allocate bank transactions in Quickbooks:
 1. Open your QuickBooks Online account.
 2. Navigate to Bank Transactions.
 3. Select any bank transactions lacking invoices/receipts.
 4. Allocate these to the chosen category. QuickBooks will then create matching expense transactions that move to the 'Categorised' section of your Bank Feed. ​
 
 
 
3. Managing Transactions in Apron:
 1. Once transactions are allocated to a correct category in QuickBooks, they will appear in the 'Unreconciled Transactions' tab in Apron .
 2. Assign these transactions to clients to provide the required documents (refer to <a href="https://support.getapron.com/en/articles/9323827-how-does-apron-work-with-unreconciled-transactions">this article</a> for more details).
 3. After clients attach documents, you can review these in Apron and then publish them to your accounting software. You will see that the document is linked to a corresponding transaction.
 4. Publishing documents linked to transactions updates the corresponding expense transaction in QuickBooks with new details such as category, VAT rate, description, and reference, eliminating the need for additional reconciliation in QuickBooks.
 5. Once published, the transaction moves to a 'Resolved' state and is removed from the list. To access resolved transactions later, use the filter to view them.

If you would like to upload list of transactions manually, there are the steps you need to follow:

Export transactions from QuickBooks:

1. Open your QuickBooks Online account.
2. Navigate to Bank Transactions.
3. Ensure only unreconciled transactions remain on the list.
4. Export these transactions to Excel ​

1. In Apron, click 'Upload Transactions'.
2. Select the bank account for which you are uploading transactions.
3. Drag and drop the file exported from QuickBooks in the previous step
    
   
    

1. Once uploaded, the transactions will appear under the 'Unreconciled Transactions' tab 
2. Assign these transactions to clients to provide the required documents (refer to <a href="https://docs.google.com/document/d/1Yi0t6lAuIVXjkngkETLyZR-Wh8HpJP2m0haKRpoUvCE/edit" rel="nofollow noopener noreferrer" target="_blank">this article</a> for more details)
3. After clients attach documents, you can review these in Apron and then publish them to your accounting software
4. Note: compared to the 'Direct sync to Quickbooks' option, Apron will create a bill in QuickBooks after you publish the document. You will then need to return to the QuickBooks' Bank Transactions section to perform the final reconciliation step.

1. Export transactions from QuickBooks:
 1. Open your QuickBooks Online account.
 2. Navigate to Bank Transactions.
 3. Ensure only unreconciled transactions remain on the list.
 4. Export these transactions to Excel ​
2. Upload transactions to Apron:
 1. In Apron, click 'Upload Transactions'.
 2. Select the bank account for which you are uploading transactions.
 3. Drag and drop the file exported from QuickBooks in the previous step
 
 
 
3. Managing Transactions in Apron:
 1. Once uploaded, the transactions will appear under the 'Unreconciled Transactions' tab 
 2. Assign these transactions to clients to provide the required documents (refer to <a href="https://docs.google.com/document/d/1Yi0t6lAuIVXjkngkETLyZR-Wh8HpJP2m0haKRpoUvCE/edit" rel="nofollow noopener noreferrer" target="_blank">this article</a> for more details)
 3. After clients attach documents, you can review these in Apron and then publish them to your accounting software
 4. Note: compared to the 'Direct sync to Quickbooks' option, Apron will create a bill in QuickBooks after you publish the document. You will then need to return to the QuickBooks' Bank Transactions section to perform the final reconciliation step.