Gav32's dashboard

Gav32 asked a question in FreeAgent Central on September 15, 2008 06:43:

corporation tax

Hi guys, I just noticed this morning that when looking at my balance sheet, and specifically 'current liabilities' and then 'corporation tax' --> when you drill down into what makes up that number, it is icluding corporation tax for 2006/2007, 2007/2008 and 2008/2009, but within the 2007/2008 number, it is working this up to 20 June 08 and then double dipping this with the 2008/2009 number from April 08? Might be a glitch?

Cheers,
Gavin

Gav32 replied on September 11, 2008 09:53 to the question "Delete downloaded transaction" in FreeAgent Central:

Yes, maybe you could e-mail me the questions to my e-mail address .... gavin@esslemont.ltd.uk

Many thanks,
Gavin

Gav32 replied on September 10, 2008 20:12 to the question "Delete downloaded transaction" in FreeAgent Central:

Yeh sure. When I ended the relationship with my accountant at the end of 2007/2008 financial year, they had to reconcile all the ins and outs of the company's finances and transfer to me the cash remaining in the company bank account, which they were managing (all income and expenses they were administering). It took them until June to work out that they were due me 14k in surplus cash (retention of corporation tax for 2007/2008, retained profits in the company etc). So meanwhile, I was historically inputting all the transactions for the company which were on each contribution statement that my accountant prepared for me each time they paid out a dividend. But when I had finished inputting all the historical data, the bank balance reflected in FAC did not match that which was in the company bank account, a difference of some 12k. My accountant said it was nothing to do with them, but by checking off each transaction on the contribution statements with what was in the FAC bank account, I managed to isolate the 12k, which was down to them withholding from me a calculation for PAYE/NI, CT, pension payments, etc etc,., but actually paying out to HMRC, pension company, less than what they were retaining from me. When all this was tallied up, it amounted to some 12k. To in summary, they are due me 12k, which is already accounted for in FAC through all the historical data. The 12k bring up my company bank account balance right in line with the bank account balance reflected in FAC.

Does that make sense?!?

Gav32 replied on September 10, 2008 05:50 to the question "Delete downloaded transaction" in FreeAgent Central:

Sorry to be a nuisance Ed/Stuart - any ideas on how to delete the downloaded transaction, or even better, perhaps manually inputting a credit transaction for the same amount with an explanation for the credit, so that the credit does not appear as an entry on the balance sheet or P&L?

Thanks

Gav32 replied on September 09, 2008 18:27 to the question "How can I upload a printed timesheet?" in FreeAgent Central:

This is a brilliant suggestion .... not about letting the free trial lapse, but about the uploaded signed timesheets. Because this is the only document which is facilitated outwith FA and I keep these week after week in a folder on my pooter. Really looking forward to this update happening! I think we should vote on moving this suggestion up the list!!

Gav32 marked one of Ed Molyneux's replies in FreeAgent Central as useful. Ed Molyneux replied to the question "Carried forward / distributable figure".

Gav32 replied on September 09, 2008 18:16 to the question "Carried forward / distributable figure" in FreeAgent Central:

Understand, thanks very much for the explanation Ed.

Gav32 replied on September 07, 2008 22:45 to the question "Delete downloaded transaction" in FreeAgent Central:

By the way, just as an update, thanks to the download function on the bank statements, I managed to manipulate the data (by using the filter function in excel) and I have now isolated, what I think is, a 12k error by my accountants, which has been nagging me for months now! Thanks again!

Gav32 replied on September 06, 2008 09:22 to the question "Delete downloaded transaction" in FreeAgent Central:

Hi Ed/Stuart - Downloaded bank transactions a couple of nights ago and perfect! This gives me what I need to be able to check the accountants statements over the past 2 years against FAC entries ... hopefully now I will be able to isolate where the difference is (by checking off each entry).

The only thing remaining is to work out how to delete a downloaded transasction?

Thanks!
Gavin

Gav32 replied on September 02, 2008 16:30 to the question "Delete downloaded transaction" in FreeAgent Central:

Hi Stuart - My accountant came before FAC, so they were managing all my affairs. I gave them the vote of no confidence and trying to reconcile their management of my company bank account. So, they provided a reconciliation of all the ins and outs of the company and after all that was done, they were due me a transfer of £14kish to transfer into my new company bank account (they were holding all cash in and out too). So this is why I need to delete that transaction into my bank account since I have inputted all the data into FAC historically and therefore in reality that transfer should not exist.

With regard to your question Ed, I'm trying to isolate why there is a difference between my bank account in FAC (a combination of manual entries and now downloaded entries) and reality of my company bank account (some £20k difference). The £14kish transaction accounts for that amount but trying to find where the other £6k is. If I could manipulate the data download from the FAC bank account, I could check off the transactions itemised with my current accountant against those transactions already inputted into the FAC bank account.

Does that make sense? Might be worth having a chat for more clarity?

Cheers,
Gav

Gav32 asked a question in FreeAgent Central on September 02, 2008 06:15:

Delete downloaded transaction

Hi there. I have a downloaded bank transaction I need to delete or be able to explain in such a way that it doesn't add to my bank balance! The reason I want to delete this transaction is because it is a payment from my accountants whom were facilitating my company affairs. Once this was all transferred, they were due me 14kish. But in actual fact, this 14kish is already accounted for in the manually inputted bank statement. So at the moment, my bank statement balance in FAC is showing 14kish more than it should do.

Any ideas?

Also, I was wondering if there was any update in being able to download bank statements to excel in full (including all fields shown in online statement) so that I can manipulate the data for doing checks on my accountants figures (information that is not available through FAC).

Many thanks,
Gavin

Gav32 replied on September 01, 2008 19:05 to the question "'Live' available distributable dividends" in FreeAgent Central:

Yep, it does Ed. Thanks!

Gav32 marked one of Ed Molyneux's replies in FreeAgent Central as useful. Ed Molyneux replied to the question "'Live' available distributable dividends".

Gav32 asked a question in FreeAgent Central on August 30, 2008 18:33:

'Live' available distributable dividends

Is there a function in FAC that allows me to see at any time the available distributable dividends, taking into account regular payments made to my current account (out of the business account) 'on account' for dividends which have been reconciled from the uploaded bank statements? Does that make sense?!? :)

Gav32 replied on August 04, 2008 21:32 to the question "timesheet" in FreeAgent Central:

Yep, talking about the timesheet reports. Just e-mailed you my current timesheet (which isnt perfect by the way - adopted it from my agent)! Also, as mentioned in the e-mail, might be an idea to alter the signature blocks at the bottom to read 'contractor' and 'supervisor' as strictly speaking, there isn't an 'employer' and 'employee' relationship. Cheers Olly, looking forward to hearing an update!

Gav32 asked a question in FreeAgent Central on August 04, 2008 20:39:

timesheet

Hello folks, Is there any way of generating timesheets in days and not hours? Maybe having the hours in the comments field? Also, would be nice to be able to edit the timesheet to include some text, such as "Hours/days certified correct by Client". I can email you a copy of my current timesheet format for info, which is what I am trying to replicate through FA so that I dont have to generate two timesheets. Thanks!

Gav32 replied on August 04, 2008 18:10 to the question "How do I insert my National Insurance number on payslips?" in FreeAgent Central:

Great, thanks!

Gav32 replied on August 03, 2008 11:15 to the question "How do I insert my National Insurance number on payslips?" in FreeAgent Central:

Hi Ed, I wondered if there was any update on this fix? Cheers!

A comment on the problem "ability to record timesheets by the hour but invoice by day" in FreeAgent Central:

Hello there. I would like to request that when generating weekly/monthly timesheets, this can be done in days as well as/instead of hours. This is kinda linked to the topic previously. The reason is my client signs a separately generated timesheet which is an excel spreadsheet, which is just 1,1,1,1,1 = 5 days per week. He does not really care about the hours I do, although I like to see it so that I can record the actual hours I have worked. is there an easy fix for generating timesheets in days?

I'm wondering if there is a user-specified function can be added to the project details area, where the user can set the parameters for charging a half-day or full-day, ie.

Project to be recorded in days, hours or both (invoicing and timesheet)? Tick, Tick or Tick
If days, one half day shall constitute [insert] hours or less.
If days, one full day shall constitute [insert] hours or more.

Hope that makes sense and not too complicated. If it would be, is there any way of just having a function whereby I can print a timesheet out in days so that I don't have to generate another one?

Also, one last thing, I notice in the timesheet generation that the formatting is slightly out in the description of service? I don't think it is wrong, just maybe should look better if the description was 'justified' - just a suggestion.

Thanks!
Gavin – Gav32, on August 03, 2008 06:39

Gav32 asked a question in FreeAgent Central on July 16, 2008 22:07:

download bank transactions to excel / csv

I have just tried to download all the transactions inputted into freeagentcentral to excel using the export feature. When I opened the CSV file, and the tab for bank account entries, there were no dates against any of the transactions and I could not sort the data by value as the values must be in some sort of text format (couldnt change this column to recognise currency).

is there any other way to download the bank statements into excel so that I can manipulate the data for my own purposes? If not in the software, is there any way that you could do this for me.

I'm trying to identify why there is a different bank balance in freeagentcentral to that which I have in reality in my company bank account!

if I could have the bank account data in a sortable fashion, I'm hoping I can identify the difference quickly.

Many thanks,
Gavin