Prevent Journal Entries to Quickbooks

SUGGESTED

We have Timeslips 2014 with TAL Pro and Quickbooks Accountants Enterprise Edition 2014.  How do I get Timeslips Invoices to be imported to Quickbooks as invoices into A/R rather than journal entries?  Invoices at our firm are generated in Timeslips and paid through Quickbooks, but journal entries prevent payments from being applied to invoices.    

  • 0

    There is no way at present to send invoices over as anything other than journal entries.  The big question is why you want to send the invoices over. Set up the link on a cash basis and then you don't have to worry about it. That is the common setup and Timeslips tracks the AR. If you do send the Invoices over as the journal entries you need to make sure you match the payments up to the invoices in QuickBooks or your income statement will be wrong if run on a cash basis. 

  • 0 in reply to Caren2

    Being an accounting firm with many clients using Quickbooks who we then bill and who are comfortable with the GoPayment system for payment as well as Quickbooks direct integration with LeCerte and ProSeries, we have strong preference for Quickbooks. We also do our accounting on accrual basis and do not allow journal entries to our AR account. Does anyone have a good workaround for less sloppy integration between Timeslips and Quickbooks?

  • 0 in reply to notgodjustadmin

    I am not sure I would use the word "sloppy" to describe the integration. I understand that it doesn't meet your needs. The integration, with the substantial improvements that took place in the 2014 version, works very well for most firrms

    The only way I know of to accomplish what you want would be to setup reports in Timeslips and export to excel. Then use a product like Transaction Pro Importer to do the imports into QuickBooks. Even then I don't believe there is any way to have QuickBooks match the payments with the invoices automatically. QuickBooks does not have an ability to allocate partial payments in any way other than proportionately so there is a disconnect between QuickBooks capability and that of Timeslips. In this case the ability of Timeslips is superior.

  • 0
    SUGGESTED

    You also can't get decent QuickBooks deposit/payment reports from journal entries, so I do this with Timeslips 2011.  First, run the G/L transfer report, printing to Excel. When TS wants to post the entries, say NO. Switch accounting links from TAL Pro to plain TAL (all accounts can be assigned 100 here) and this time, after  running the G/L report, again printing to Excel, say YES when asked to post. The first G/L transfer gives you all the client/matter names and numbers necessary to create QB invoices, while the second G/L process marks the entries so they don't show up again. Also, printing (and saving) everything to Excel makes it a lot easier to find out what went wrong where. Once you're done you can switch back to TAL Pro, then close and restart TS (it loses synchronization when switching accounting links). This last step is just how I do it, which may not work for you. Opening the transfer worksheet created by TS (I keep transfer and posting in separate workbooks), I sort by transaction type and invoice number, then hide all rows other than invoices, and all nonessential columns, use table formatting to shade the rows, then print. Creating QB invoices is easy as the worksheet has everything I need - client/matter, invoice number, assigned accounts with amounts owed, and ends with the total due for each cross-checking.

    I know it seems like a lot to do, and it was when I first started (right after my first encounter with the TS method of posting entries), but after I got the routine set up, it's actually easier.  I can enter invoices, fix little mistakes that don't always show on the bills, and process payments, all when and how I want. I've been doing this for a few years now and still like it.

    Liz D

  • 0 in reply to Liz D

    With Timeslips v2014 you can setup the link and then just choose to mark the entries as posted without all the steps.