TAL GL_Transfer Register not displaying all transactions from Timeslips

I have two issues with the GL_Transfer Register

The monthly register randomly excludes transactions from clients including payments, invoicing, etc. There is no consistency as to which clients are excluded.

I have never seen a debit to the Suspense Account on the register except for when a refund is issued.  I print the report and do a manual entry into the Sage 50 GL.

My Sage Accounts Receivable balance is less than the Timeslips AR balance by the exact amount of the refunds that were issued in February.  In order to adjust my AR in Sage I need to debit AR, but my only option is to credit Income (which doesn't seem right).

The Suspense account in Timeslips repeatedly causes me issues. Overpayments are "applies to future invoices" but there is never an adjusting entry to reclassify the overpament - please help!!

  • 0
    It would really help to know what version of Timeslips you are using. Would probably need to take a look at your setup to really understand what is going on. I am not a big fan of setting up the link on an accrual basis which is what it sounds like you are doing. However, if you issued refunds then you need to know what you were refunding. My best guess is suspense so the credit would be suspense. Did you run invoices after you issued the refunds? That is when the entries to remove the money from suspense would post.
  • 0 in reply to Caren2
    Timeslips 2015, and yes the link is on the accrual basis.
    I set up the link in January of 2015 and all was good until September when client transactions were missing on the report.
    Prior to 2015 - the amounts on the Totals Only Worksheet after billing were used for the GL Entries.

    The GL Report has NEVER showed a debit to Suspense and I do not post to the Suspense account in Sage. I adjust the entry and the credits for Suspense are subtracted from the AR credit amount on the report.

    See example 4B on page 4 - this doesn't occur on my register report so as far as I knew - Timeslips was doing something in the background that I couldn't account for. www.beyondmanagement.com/.../timeslips_tal_suspense.pdf

    The refunds were issued from Sage 50 in the middle of February (debit to refunds, credit to payable) and recorded in Timeslips prior to the February invoicing.

    I work for an engineering firm, and Timeslips really isn't capable of tracking what we need, but it's all I've got now. Until I can replace it, I'd like to know that the translation from Timelslips to Sage is being done correctly.
    My understanding of Timeslips is limited, and my staff members who "know" Timeslips have little understanding of basic accounting.
  • 0 in reply to Char - ETI
    The concepts are the same but the documentation you are looking at is based on the older version of Timeslips. The link was substantially upgraded in the 2014 version. I would need to do a remote session to look at your setup. That would be billable time.
    My guess is that names are not synchronized properly and some accounts are not linked as they should be, but that is only a guess.
  • 0 in reply to Char - ETI
    My advice to you is to just hire Caren Schwartz to remote in and take a look at what you are doing to figure out what is going on and to give you some training on how the link works. Accrual basis is not as common to see with Timeslips, and I think you will solve your issue much faster and more reliably by paying Caren for her expertise than trying to do question and answer here on the bulletin board.

    Caren is one of the best at the Timeslips Accounting Link (TAL), and personally contributed significantly to the changes to the TAL link in more recent versions of Timeslips. In fact, I call her myself when I get into an issue with TAL that isn't in the shallow end of the pool. So you would be in very good hands with someone who is uniquely qualified to work with you. Getting you the right answer, quickly.
  • 0 in reply to Caren2

    There were some issues with the client synchronization which I corrected. The updated report includes those clients who had been missing.

    Caren - please email me regarding fees to remote in and review our set-up. I am searching for a program that includes project management in addition to time/expense tracking, but Timeslips will continue to be used until we find a replacement.