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:
Direct Sync to QuickBooks
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:
Managing Transactions in Apron:
Once transactions are allocated to a correct category in QuickBooks, they will appear in the 'Unreconciled Transactions' tab in Apron .
Assign these transactions to clients to provide the required documents (refer to this article for more details).
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.
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.
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.
Option 2: Upload manually
If you would like to upload list of transactions manually, there are the steps you need to follow:
Export transactions from QuickBooks:
Open your QuickBooks Online account.
Navigate to Bank Transactions.
Ensure only unreconciled transactions remain on the list.
Export these transactions to Excel
β
Upload transactions to Apron:
Managing Transactions in Apron:
Once uploaded, the transactions will appear under the 'Unreconciled Transactions' tab
Assign these transactions to clients to provide the required documents (refer to this article for more details)
After clients attach documents, you can review these in Apron and then publish them to your accounting software
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.