I'm lost completely

What are these purchases over $1,000? Equipment?

Yes, equipment for the business, speakers etc…

For these items, it’s best to utilize Fixed assets tab. Basically all items above $1,000 you can create under Fixed assets and instead of categorizing to some expenses account, use Fixed assets account.

See: Manager Cloud

BAS Worksheet is smart enough to put purchases of fixed assets under G10 field.

Thanks lobos,
i’ll give that a try.

Thanks

1 Like

Hello Othila,
Let me know if I can be of any help. I professionally work on ERP softwares.

Hi

I have just downloaded “M”. Have managed to set up the company but when I go to “cash accounts” to upload" bank statements the “cash accounts” is greyed out and I cannot get into it. Please help.

Have you gone to settings, activated the cash accounts module and then updated it (right down the bottom)? It sounds like you haven’t. Once you update it, those tabs on the left will become available.

Notwithstanding that, and if it doesn’t solve your problem, you’d be better off asking your own question instead of dragging up an old and unrelated question. You will certainly get a much better response.

That question has been solved in another thread — Bank import button missing. You have to edit the cash account, and switch on the ‘This account is maintained by a bank or other financial institution’ option.

@Pla, I thought that might have been the case and gave it a whirl myself. However, she said the Cash Accounts was greyed out, that’s why I thought she might still be in the customisation settings.

Yep, that’s true. I misread the question, sorry.

The ‘greyed out’ issue makes me think that she has not added any cash account yet. Maybe @Belinda could attach a screenshot for clarification.

Thanks so much. I have now fixed that issue but alas another. I have to convert my online bank statement from pdf to .csv. When I do so i get the following. I have tried suggested items of changing headings as previously suggested but it has not worked.

You did not include anything, such as a screen shot, to show what “the following” is.


Thanks Tut. Screen shot included. It says CSV file is missing “date” column. Driving me crazy. Have made a separate date column but it will not accept it. Please help.

How did you add the date column?

Did you just enter it on the first line of a text file with a csv extension? Or did you do it via a spreadsheet insert column and then re-export it to a .csv file?

I would guess you already have a date column but it’s either called something else or in a slightly different format.

If it doesn’t compromise your privacy, post the first few lines (inflate/deflate prices if you’d like and change some description field entries) and we can check to see that the format is correct for you. Completely optional.

Do at least the first (headers) and 2 or 3 other lines.

Thanks for the response. I just typed the date in above the values and typed in headings for the other coloumns. I deleted all the other funny coloumns to try and get it looking clean. It would not save as an csv. I then copied just those coloumns to another clean excel workeheet but again same problem. Pasted them into Word and tried to save but Word does not have CSV. Tried to attach them to you but another error so I have just attached a picture. I can email it to you if suitable.

I haven’t used excel in a good number of years, if you can’t save as a .csv is there an export option to export as... and then select csv?

I can certainly have a look for you and try importing it into a test account at this end.

How did you get it into the excel spreadsheet to begin with?

Might I suggest copying the sheet to a google sheet and share it with me. I’ll send you my google email in a PM and you’ll be able to see any changes I make.

I had similar issues importing CSV visa statements and couldn’t get the excel document to be accepted.

A much simpler solution that was suggested by others on this forum is to use a free .CSV to .qif converter and import the .qif file into manager. Works perfectly every time and takes just seconds to do.
This is the one I use.

Goodluck!

1 Like

A post was split to a new topic: How to Use the Forum

Is the date of the journal transaction within the set date range of your summary page?