cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Experienced Member

Bank statements

Hello. I´m having troubles uploading bank statements because it gives me different values when i file.

Solved
Best answer 11-20-2018

Accepted Solutions
Experienced Member

Re: Bank statements

Hi. 

 

I have done it, fortunately. It was a settings´s problem. I had to change those settings and than it worked. 

Thank you very much for your help and time. I´m sorry for spending it.

Thank you again,

 

Pedro

QuickBooks Team

Re: Bank statements

Hi Pedro

 

You are welcome. I am glad it is resolved any further questions let us know

 

Kind regards

 

Emma

10 REPLIES 10
QuickBooks Team

Re: Bank statements

Hi Pedro10,


Thank you for contacting the Community.

Sorry, I'm unsure what you mean. Could you maybe send me some screenshots of the issue you are having?

Thanks, Carly. :)

Experienced Member

Re: Bank statements

Hi. Thank you for answer me.

Yes i will send you screenshots.

 

Tanks Pedro

QuickBooks Team

Re: Bank statements

Thank you, that will be very helpful. :)

Experienced Member

Re: Bank statements

After that, this is what appears. I sent you another screenshot.

 

Thanks,Pedro

QuickBooks Team

Re: Bank statements

Hello Pedro,

 

That is quite weird how they are showing different amounts. Could you please include a screenshot of the spreadsheet data you are uploading in excel as well as the section where you map each column for QuickBooks Online. 

 

Thank you,

 

 

Experienced Member

Re: Bank statements

Hello,

 

Yes i am sending you a screenshot.

By the way, continues without giving.

 

Thank you

Experienced Member

Re: Bank statements

Hello,

 

Yes i am sending you a screenshot.

By the way, continues without giving.

 

Thank you

QuickBooks Team

Re: Bank statements

Hi

 

I have had a look at the screenshot and it looks like the columns need separating. Can you make sure each column has a separate header (date,description amount) and make sure the amount is  in a separate column as in the screenshot the entry is one long line and that there are no commas or hyphens as it does not like symbols

 

Then exclude the wrong amounts already uploaded to Quickbooks and upload the file again

 

Let us know if you have any more questions

 

Kind regards

 

Emma

Experienced Member

Re: Bank statements

Hi. 

 

I have done it, fortunately. It was a settings´s problem. I had to change those settings and than it worked. 

Thank you very much for your help and time. I´m sorry for spending it.

Thank you again,

 

Pedro

QuickBooks Team

Re: Bank statements

Hi Pedro

 

You are welcome. I am glad it is resolved any further questions let us know

 

Kind regards

 

Emma