Is there a better way? Quarterly Invoicing

SOLVED

We invoice our customers (real estate) quarterly and so every quarter I'm manually entering around 40 invoices.  The memorise recall function doesn't work great because I need to change the details of which quarter is being invoiced in the invoice each time, along with the tax point which I do as an analysis field.  The recurring items function also doesn't seem to be an option as it wants me to say how many days, weeks or months it happens rather than me being able to set the correct quarter dates (they don't quite fall an exact distance apart).  What I really want to be able to do is import a spreadsheet for each item on the invoice as I can easily copy and paste it down an excel sheet e.g. invoice date, due date, details, tax point, zone analysis etc. Is there an option I haven't considered that would save me time?

An additional complication is we invoice the rent and the management charges from separate companies so I have to do this process in two different company data sets at the moment.

Finally I then manually write an email to each customer attaching the invoices as PDFs as some of them have multiple invoices etc.  - again I've just assumed that it's too complex to do it in SAGE but am I missing something?