u/SirSeaSlug

Hi,
I work with a ... 'technologically challenged' group that would like a very simple data collection form where you just input someone's name , age, address etc and it will put it into a table or database. I would just use google forms but they require it to be offline, and with excel I could do it simply with some cell input linking to a table on another tab but ideally I would like to give it a bit more of a UI , maybe with macros, so they have a 'submit' button and it's harder to mess up input. Due to GDPR it would also need to be secure somehow too.

They had someone build them a database years ago using microsoft access but it's kind of outdated now and janky and we would all love to get them off that system.

Is there a way to do this in excel? Because there's no way they could handle a SQL database, but they basically only need a single table for the data because it's just for checking if someone has contacted them previously.
TIA!

As title suggests, looking for some advice when VAT comes up - i feel like i have everything covered but this.
For example, I did a question where there was a disposal of an asset, they were vat registered, and the asset was 18,000 plus vat. On disposal it had a part exchange value of 10,000 plus VAT.

I had to create the disposal account and got everything right except for VAT which I included as a debit entry to account for it as this had come up on a different question and got the whole thing wrong because of it. I also never know if I should include the totals in accounts as net or vat - I know that the RLCA/PLCA should always INCLUDE VAT for example-

Basically, is there any way to know how to tell if i should include it as net or vat when i enter it into accounts, or as a separate entry, or is it just case by case memorisation?

This is honestly really stressing me out so any help appreciated :) thanks

Bit of a basic question , if there are wrong entries (under/overstated figures in daybooks or ledgers like payables/receivables) do we then correct those using the control accounts rather than the original ledgers where the wrong entry is?

e.g. understatement of £100 in purchase daybook, correct by CR £100 in Payables Ledger Control Account because liability increase?

I just want someone to let me know if my understanding is right and if not or there's anything to add, to help out if possible

So when you do the ETB for a year you do the opening inventory figure first, which as an expense is DR on the P+L.

Double entry:

DR P+L
CR inventory

then when you do closing inventory for the year it's an asset on Financial Position but we do:

DR inventory
CR P+L

I'm a bit confused about that logically because we DR Financial Position after to record it there as an asset but it's not tied up in double entry really , so,
Think i'm mainly just unsure about the reasons for that last double entry.

I understand how to value closing inventory ( lower of cost or sale) and opening (purchase + COGS - closing) but I don't get the logic of a lot of it.

I'm also unsure about the opening calculation (purchase is raw resale items, plus the cost of the goods you sold? minus last years stock? I would have thought it would be last years closing inventory + purchases and then minus what you've sold..

If anyone can give help that would be great :)

What is the difference (and what do i do differently) between depreciating something in the year of sale vs the year of purchase?

Hate to ask for so much help here but:

Basically for partially exempt businesses (selling mix of taxable and exempt supplies) I understand that for input vat relating to expenses such as rent, utilities, that cannot be directly attributed to either exempt or taxed supplies, you can carry out the residual income test.

However,
for de minimis test, I am unsure as to whether this applies to the residual input (relating to both supplies but excluding that which can be directly attributed to exempt) or for both the non direct and the direct input.
I've seen it say all input , so basically both of these?

Thanks 😄

Hi,

i'm struggling a little with the future turnover test for VAT because i'm unsure which is correct:
I know that if , say, my taxable turnover is at £70k and I have a contract that will create a sale in the next month for £50k then I fail the future test as that month alone will push me over.

And i've been taught that huge sales like that are the way it works.
But if I have £16k a month regular turnover and i'm in May (so currently i'm at £80k) and I know that next month will push me past the £90k limit, does that still count at failing the future test? I think with regular monthly turnover like that it's assumed that it's by the end of the month that it will push past it,
and i've seen differing answers on whether it fails future or historic test mainly.

Does knowing that your regular pay will push it past the limit count as 'reasonable grounds' for believing you'll exceed it?
Or does it not count because it's not set in stone that you will get that amount.
I think it's debatable but need to know what AAT think because it changes the date by which you need to register, and thus the answer to a question!

Thanks 😄