Bank statement Import

[Terrymac]

Hi all,

I have been reading the forum looking for a solution to my issue but cant find anything relevant.
Herewith my issue and or lack of understanding.

Have exported my Bank Statement using CSV, QIF and OFX

It brings in the statement OK however no Values on the first screen after you have imported to Receipts\Payments. However if I click on Find & Recode the values are there!
Is this how it is supposed to be?

I know CSV is the not the best solution, however it is not bringing in the data via QIF or OFX either

Also I have created a rule, that when the statement contains a common number it will place the item to sales, does not happen

Yours in great anticipation

[Patch]

@Terrymac

It brings in the statement OK however no Values on the first screen after you have imported to Receipts\Payments

Manager detects bank transactions which have already been imported and skips over those transactions if they are included in a later Bank import.

@Terrymac

However if I click on Find & Recode the values are there!

Consistent with these transactions importing successfully the first time you did it.

It is likely you will see these transactions if you

• drill down on the “Suspense” account or

• Go to the bank account, there will be a column labelled “Uncategorized transactions”

Then drill down on the number of transactions

@Terrymac

I have created a rule, that when the statement contains a common number it will place the item to sales, does not happen

• The rules you have defined will show as suggested edits to your raw bank statement import

• Check, edit, and create new bank rules as appropriate

• To apply these edits, select the transactions with rules you want to apply (select all will select all with a bank rule suggested edits) then click “Batch update”

For further details see the relevant guide https://www.manager.io/guides/9240

@Terrymac

I know CSV is the not the best solution, however it is not bringing in the data via QIF or OFX either

It is more likely all are working. You will have to look in detail at the imported data to see which is most accurate from your banks implementation.

[Tut]

@Terrymac

however no Values on the first screen after you have imported to Receipts\Payments.

What does this mean? What “first screen” are you referring to?

Your bank rule is also incomplete. It does not contain a payer or payee.

[Terrymac]

Good Morning Tut, do you ever sleep
Ok first screen I am referring to is the RECEIPTS Tab

Then when I click on the tab Find and recode the amounts are there. The above was imported by QIF

In regard to rule I was thinking that however it only gives me a choice of Other, Customer or supplier
I in fact need it to go to a GL code, was not sure if this was possible. The money is coming in from Internet sales via Paypal and Stripe, Should I therefore set up a CASH SALE account as a customer then allocate to that?

[Tut]

@Terrymac

Then when I click on the tab Find and recode the amounts are there.

Do you mean amounts or accounts?

@Terrymac

In regard to rule I was thinking that however it only gives me a choice of Other, Customer or supplier

Those are categories. You need to choose the appropriate one and supply a name.

@Terrymac

I in fact need it to go to a GL code

Your Sales account is a GL account.

@Terrymac

Should I therefore set up a CASH SALE account as a customer then allocate to that?

No. You are not selling on credit. So use Other.

[Patch]

@Terrymac

first screen I am referring to is the RECEIPTS Tab

If you click the edit button for any of those receipts you will see you have not told Manager which account it should be received in.

You can do that individually or as described above, go to your uncategorised transactions and and apply your bank rules to specific transactions