QuickBooks users benefit from easy import with Telleroo, saving time and avoiding manual custom CSV files. Here’s the process:
Add payee bank details to QuickBooks
For each payee, you need to add their bank details into QuickBooks. As QuickBooks does not have an official location to store these, you need to add them into the phone number field.
To do this go to Expenses > New supplier / Click existing supplier name > Add bank details to Phone.
Start with the payee’s sort code, followed by the account number. Leave no spaces between the two e.g. 12345612345678
Export unpaid bills report
Go to Reports > Find Unpaid Bills report > Export to Excel
For a successful import into Telleroo, ensure that the columns are in this order (left to right); Date, Transaction Type, No., Due Date, Past Due, Amount, Open balance.
Below is a correct example:
Import into Telleroo
Now it’s time to import into Telleroo. You can find out how to do this with a video and article below.
Coming soon: QuickBooks integration
Say goodbye to manual data entry with Telleroo's new integration for QuickBooks. Pay QuickBooks invoices directly from Telleroo.
Join the waitlist today to be notified when the integration is live: https://www.telleroo.com/integrations/quickbooks